Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Microsoft Equivalent to Oracle's Deferred

Author  Topic  dtucker Starting Member 4 Posts Posted - 2006-08-09 : 09:11:22 Does anybody know if SQL Server (2005 if it matters) has an equivalent to Oracle's defferred contraint checking. [url]http://www-db.stanford.edu/~ullman/fcdb/oracle/or-triggers.html#deferring%20constraint%20checking[/url] I want to update the key used in a primary/foreign key relationship from an "INSTEAD OF UPDATE" trigger. I do not want to use cascading. Any help would be greatly appreciated. Thank you, David