Tag Archives: SQL Server
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 Function, Remove Special Characters, Replace Special Characters, SQL Server, TSQL
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
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 Drop Constraints, SP, SQL Server, Stored Procedure, TSQL
Leave a comment
