Category: SQL Server

Simulating ON DELETE CASCADE

See how to generate a set of scripts that will delete rows from dependent tables and show you how many rows will be deleted from each.

Document Columns Across Systems

Find out how to use dynamic SQL to quickly generate metadata queries to pull attributes for all columns across a database or even a set of databases.