SQL Server Programming Part 15 - DML Triggers

By Andrew Gould

You can see a written version of this tutorial at:

You can download the script to create the Movies database used in this video at the following link:

You can see the range of resources and courses we offer in SQL Server here:

[izapawlukowska]

My TSQL test is tomorrow and your videos are my lifeline. Thanks a lot for your work.

[am-withlearnuel]

your are really good at this, you are not in a rush you take your time and explain every step of the way. Your really helping with this good work. No matter how tough the topic once i go through you tutorial i understand perfectly

[ddunn]

Thank you so much for posting this video.  I have a final exam coming up and I've been leaning heavily on your videos to get me through this semester of SQL Server 2012 !

[saagarsoni]

sir very quality teaching for SQL your videos are very crystal clear....thanx a lot...thnx...

[fadwa]

EXCELLENT AS USUAL Andrew!!
Thanks a lot

[sweetsazd]

Your videos are super simple and easy to understand! Thank you :)

[vladilucz]

this tutorial is absolutelly great, keep up the good work, really helpfull

[dheerajlxst]

Thank you this really helps me prepare for my exam!

[nickt]

@15:43...So can I think of it like this... If new row that is trying to be inserted DOES HAVE a DateOfDeath in the Actor table then send them the error message.

If however, the ActorID of the row trying to be inserted does not have a DateOfDeath in the Actor table, then rows get inserted from `tblActor` to the `inserted` table. And then from the `inserted` table they get inserted into the `tblCast` table

Do I have that right? Is that basically what is going on behind the scenes?

[krzysztofmaciak]

Thx for the video. One question - how could you rollback transaction (15:42) within trigger while none was opened ?

[koroslav]

Thanks for the video. It helped me a lot.

[Unearthed]

Those poor Star Trek red shirt people :-( great video Andrew, thanks :-)

[mohamed-fatta]

thank u again i know ur vids are a bit older but still useful <3

[mcallisterbeacon]

'tom cruise as random redshirt' hahaha

[albertma]

Hi, Your online tutorial is really good, clear and efficient. the only problem is when I try to open your 'Movie' database which I download from your website as .sql file using SQL Server 2012, the queries are completed with errors. The result is that I only get few tables  which is far form complete. Do you have any solutions? Thanks.
Oh, by the way, when I open the movie.sql file, there is a error box saying something like "  some bites are replaced with .... saving will not keep the original content"  I don't know whether this gives you additional clue. 

[adekupx]

Hello Andy, thanks fro your these videos, they are really educating. I have an update version of Movie data that was used in this video. i do get an error : The column 'FullName' cannot be modified because is it either a computed column or is the result of a union operator. How do i get around this error message. hope to hear from you soon.

[krantikumar]

I want to write a query in trigger like: whatever i updated/deleted/inserted in table 1 that updated old data of table 1 should transfer to table 2... how can i write? please help

[kevinike]

Can i use both the After and Instead Of triggers at the same time?

[nugan]

Good Article. Thank you.
Could you please share knowledge on Locking and Isolation levels in SQL Server

[jesusmtz]

Great! Can the BEGIN END include running some python code?