SQL Server Insert, Delete and Update Triggers

[@SilverTechSys]

I couldn’t explain it better myself if I new it at that level, thank you for taking the time to explain it in detail.

[@beardboyphotography]

Thats a perfect video explaining the triggers, Thanks a ton Lisa!!

[@TheBIHARIS]

Thanks for the complete step-by-step explanation.

[@omotayoogunnika6865]

Thanks for sharing, your video helped me to create a Trigger i've been trying to create for about 1 week & half prior.

[@monicacastillo1183]

Thank you so much! You're a great teacher!

[@skdonsingh]

Thank you ma'am
It was nice explanation.

[@hafizarahman9999]

I am new on this, and this is help me a lot. Thanks so much!

[@praji1202]

I'm having a table with some data, and when there are some changes done to this table I need to create a trigger which will insert these changes to an already existing table but in a new column

[@Danitolonz1]

Hi Lisa! You're such a sweetheart and I love you so dearly!
Please in what scenarios should I defer to use Stored procedures over UDFs and vice versa? Wen should I use SP and when should I use UDFs?

[@john_yeager]

very nice example thanks

[@neyon7824]

hi. thanks for the video.
How come it still shows messages even after SET NOCOUNT ON??

[@fealgu100]

Thanks, Lisa!

[@gunavamshi690]

Hi lisa , Nice video but how can we get the count of the number of the rows we have inserted using triggers

[@umutogur391]

Thank you so much for your useful video.

[@longle7603]

Thanks Lisa, This really helped me out.

[@jasonmichaelalunan2492]

Thankyou maam lisa!!! This really helped me out ^_^

[@ibrahimhussain3248]

If there was a insert with multiple rows at the same time from a table variable or multiple row inserts in same statement, all those triggers would fail since it is assigning INSERTED.[ColumnName] to a variable. You could just do
INSERT INTO [dbo].[CustomerLogs] SELECT INSERTED.[CustomerId], 'Inserted' FROM INSERTED;

[@christiandebellefeuille3245]

yup. In fact INSERTED is a virtual table. So you can do an inner join with it to do your stuff. For example, if you have to udpate multiple rows.

[@ShahnazMalik.]

Brilliant, you deserve a lot more subscribers. Keep your work up
Do you have any video series on python, Azure and data science ML or AI?

[@radoslavdimitrov7505]

seems like in SQL Server 2022 there are not inserted or deleted pseudo tables and views. What should I use to make such triggers instead?

[@marsdriver2501]

there, sql server management studio is just being dumb probably

[@solodevelopersolo]

Amazing work

[@leroypalmer9226]

Great video!

[@TecnologySoft]

Estos ejemplos ya son muy comunes, q no saben hacer algo más complicado, y algo diferente

[@bc-ei4nc]

amazing video !!!! Thanks!

[@nedu47]

How did you come up with CustomerLogs?

[@michaeljames4440]

customerLogs is just a regular table that was created to keep track of triggers initiated

[@vaitheesvaranv4108]

Thank you so much

[@satchijena]

Excellent !!!

[@gotchihaeyo1825]

It's very hard to see and read

[@S2100211]

Good video but the sound quality lets it down.

[@grk608]

Hi Lisa, This is an AWESOME video but I'd like to know if you can help me take it a little further. I'd like to track WHAT changes were made, as well as WHO made the changes and on WHAT date and time. I'm super brand new at this but using this video, I was able to get some triggers up and running. Can you help or maybe point me in the right direction? Been all over youtube and I'm coming up dry. Thanks so much for all you do. -Glenn

[@christopherkiraly]

Also, what if more than one thing was updated?

[@alionessprincess]

I can barely see the text.. too small!

[@samikariem4298]

DUNK SCHONE

[@Sachinkumar-qg7cp]

Very helpful🫡

[@koserrist6977]

ZA DUZO GADASZ