SQL Server Programming Part 15 - DML Triggers

[@izapawlukowska4545]

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

[@WiseOwlTutorials]

Good luck with your test!

[@4am-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

[@ddunn10]

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 !

[@emielvanbelle7352]

This man is an actual legend

[@WiseOwlTutorials]

:D thanks Emiel!

[@roytshop8488]

Indeed

[@saagarsoni3]

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

[@sweetsazd11]

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

[@fadwa2413]

EXCELLENT AS USUAL Andrew!! Thanks a lot

[@WiseOwlTutorials]

Thanks! :D

[@8Kexperience]

Good work! Keep it up.

[@albertma6006]

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.

[@dheerajlxst9141]

Thank you this really helps me prepare for my exam!

[@vladilucz2833]

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

[@ericrouach]

great explanation! thanks a lot!

[@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.

[@krzysztofmaciak1611]

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

[@nickt423]

@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?

[@Unearthed13]

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

[@koroslav]

Thanks for the video. It helped me a lot.

[@jesusmtz29]

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

[@WiseOwlTutorials]

Hi Jose, you can run Python code using the sp_execute_external_script system stored procedure,. You might find this page useful docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-transact-sql?view=sql-server-ver15 as it explains the pre-requisites for executing Python in SQL Server, I hope it helps!

[@mohamed-fatta]

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

[@laszloneduka8875]

Thank you.....

[@WiseOwlTutorials]

You're welcome again!

[@SomebodyOutTh3re]

Thank you!

[@nugan8323]

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

[@krantikumar4048]

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

[@christianrodier3381]

That was great

[@kevinike1344]

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

[@mcallisterbeacon]

'tom cruise as random redshirt' hahaha

[@AnilKumarP4U]

Videos are great.Please share the movie database link. Thanks..

[@AnilKumarP4U]

***** Thank you :).

[@balajis8279]

Hi, your tutorial are really good .I have one doubt in this tutorial how we are able to rollback because we never begin transaction anywhere pls somone reply thanks in advance

[@balajis8279]

WiseOwlTutorials Thank u thanks a lot keep doing this great stuff

[@saagarsoni3]

Sir can u tell us ,HOW to send Email using SSMS ??

[@saagarsoni3]

***** sir can u please upload a video on this topic,means how to configure email? Please..