Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain ... CREATE TABLE SalesHistory SaleID int IDENTITY(1,1) NOT NULL, Relationships ...

In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations ... followed by an insert of the new row.