Mutating table in SQL Server 2000 triggers

[fixthebug2003]

Hi,
Is there a concept of Mutating table in Triggers like we have in oracle triggers.
In Oracle, A mutating table is a table that is being modified by a DML. So for a Trigger, a Mutating table is the table on which the Trigger is written.And the rules are :
The SQL Stmts in a Trigger Body may not:
1.Read from or Modify any mutating table of the triggering stmt
2. Read from or Modify the primary, Unique or Foriegn Key Columns of a constraining table of the triggering table. They may modify the other columns if desired.

Is there any rules like this for Triggers in SQL Server 2000?

Fixthebug2003

 

[JoeSack]

Hi,

I'm not an Oracle guy - but I did do a little research on your question. From what I've read, there is no SQL Server issue with referencing modified data. SQL Server statement level triggers are allowed to reference the changing data, and will not produce a mutating error.





Best Regards,
Joseph Sack,

http://www.JoeSack.com

Author of "SQL Server 2000 Fast Answers for DBAs and Developers".