Friday, July 13, 2007

2 quick notes on SQL Server Triggers

Because there is a lot of misleading and contradictory information on the web about this. I encourage you to test this for yourself. Don't believe it just because someone says so on the internet! - I learnt the hard way ;)

A trigger (insert, update or delete) will get called only once, even if more than one row is affected.

Update and delete triggers will be called, even if no rows are affected.

3 comments: