SQL Server allows you to define cascading referential integrity constraints. These actions have a trickle-down or cascading effect, sometimes affecting several tables that were related to the ...

I've got an interesting constraint I'm trying to add ... if there is a more elegant way to do this in T-SQL (SQL2005, FWIW) We have two related tables to hold data on a master class in one table ...