Introduction to Instead of Triggers

Normal triggers fire after a insert, update, or delete statement but are part of the transaction. Instead of triggers allow us to change the outcome in interesting ways - for example, we can convert a delete statement into an update that just marks rows as deleted.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Wenda Stephens on 10/18/2009

Do not know what I would use it for right now, but an interesting nugget to store in the back of my mind.

Sande Jones on 10/23/2009

Very Nice! That will come in handy

Leonard Peoples on 10/26/2009

Very nice, it gives me a lot of ideas of ways to use it.

John on 10/26/2009

Great stuff. Love your videos - THANKS!

Holck on 10/29/2009

very cool

Wajih on 12/18/2009

Nice Example!!!!

SpeedRoush on 12/24/2009

1st viewing--> ya lost me 2nd viewing--> light bulb came on

Nasar Azam on 12/30/2009

Nice Intro

Kristeen Sellers on 1/14/2010

This is a wonderful thing for history. Taking the history out of the app and putting it totally in the database

A Alagu Ganesh on 1/20/2010

Very Good

James Lawrence on 3/11/2010

Very informative and useful!

suman on 7/8/2010

very useful..thanks

A Alagu Ganesh on 10/14/2010

Good

Amruta on 1/21/2011

nice

Jim McKinstray on 1/21/2011

Straight forward and to the point. Very well done.

Michael on 1/21/2011

Great Video. Quick, to the point and informative

Michael on 1/21/2011

Wow! I had no idea about this tool. Thanks for letting me know about it.

Jack Hellmuth on 1/21/2011

Could have used more explanation. I was not sure how this could help without changing application code to look for the new deleted field.

Mick on 1/21/2011

Simple, straightforward and useful. Great example

John Torrey on 1/23/2011

I'm curious how well this would work with inline SQL and where clauses. Very interesting.

John on 1/23/2011

kewl - always wondered when you nmight use this

Mohamed Irshad on 1/24/2011

Have had this sort of requirement and wondered how to achive without modifying the app. Thank you for this excellent demo.

Kasey Wheeler on 1/24/2011

Good video.

Jason Yousef on 1/31/2011

Thanks

Randall Price on 2/3/2011

This is the most amazing way I have seen to date to setup use a Delete column on table to track "deleted" records without having to actually do the delete or move the deleted record to an archive table. Great demo.