Tag Archives: TSQL

Remove Special Characters from a string in SQL Server

Here is a sql script which I found on some forum while searching for the same which I thought is interesting enough to share. This script can be used to remove special characters from a string in SQL Server – … Continue reading

Posted in Technology | Tagged , , , , | 3 Comments

Generating pivot table dynamically

In the above query there are two tables Subjects and Days, one contains entries for subjects and other for holding days of week The generated pivot tables is like a time table which contains value 1 for the day where … Continue reading

Posted in Technology | Tagged , , | Leave a comment

Drop all the constraints on a table

Following sql snippet illustrates an example of dropping all the constraints on a table. This stored procedure takes table name as parameter and dynamically creates a drop script for all the constraints of given table and executes it. Earliar today … Continue reading

Posted in Technology | Tagged , , , , | Leave a comment