Triggers in SQL Server

[fixthebug2003]

Does SQL Server has Row Level Triggers?

 

[JayKusch]

Define what you mean by "Row Level Triggers" to make sure everyone is in agreement as to the definition.

Thanks

J. Kusch

 

[fixthebug2003]

In Oracle you have Row level and Statement level Triggers.
Row Level: The trigger fires for Every row.
Statement Level: The trigger fires only once for any change in the table. Mostly used for Transactional processing.

After Reading a little on Triggers in SQL Server ..looks like SQL Server 2000 does not have Statement level Trigger..may be I am wrong

Thanks
Fixthebug2003

 

[nigelrivett]

A trigger in sql server fires once for an sql statement - if the statement affects mor ethan one row these can be referenced in inserted and deleted and joined via the primaty key.

If you need to preform row by row operations then the primary key can be used for that too.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[nigelrivett]

>> A trigger in sql server fires once for an sql statement
Except for recursion.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.