Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.
Runtime: 3:01 minutes
|
| |
These videos are provided by JumpstartTV and End to End Training
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,242 reads
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
2009-07-07
7,505 reads
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,808 reads
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
2009-03-17
4,840 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,391 reads
