Monthly Archives: December 2009

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