By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point. Skip ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and ... Updates of key values from ... Also, the use of an ORDER BY statement is necessary, as is the use of a primary key ...