Can someone suggest a few websites (other than Microsoft) which explain
Triggers in SQL Server especially multi-row UPDATE Triggers?

Thanks,

Arpan

Hi

All triggers should be treated as multi-row as they are triggered at
statement level and it may not be guaranteed that you will never update more
than one row.

You may want to look at historical articles in SQL Server Magazine to see if
there is anything that could be useful:
http://www.windowsitpro.com/SQLServer/Index.cfm

This may help:
http://www.nigelrivett.net/index.html#Triggers
and unit 15 on http://www.mssqlserver.com/tsql/


John

You may want o

Show quoteHide quote

Cannot enter data into database
syntax error in CONTAINS query
need help with execution plan
Understanding best way to optimize...
IDENTITY Column!