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
Andy Warren, 2008-12-16
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,241 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.
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.
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,839 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.