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.

[@skdonsingh]

Thank you ma'am It was nice explanation.

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

[@monicacastillo1183]

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

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

[@gunavamshi690]

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

[@neyon7824]

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

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

[@umutogur391]

Thank you so much for your useful video.

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

[@longle7603]

Thanks Lisa, This really helped me out.

[@jasonmichaelalunan2492]

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

[@john_yeager]

very nice example thanks

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

[@TecnologySoft]

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

[@nedu47]

How did you come up with CustomerLogs?

[@michaeljames4440]

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

[@gotchihaeyo1825]

It's very hard to see and read

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

[@S2100211]

Good video but the sound quality lets it down.

[@solodevelopersolo]

Amazing work

[@leroypalmer9226]

Great video!

[@bc-ei4nc]

amazing video !!!! Thanks!

[@vaitheesvaranv4108]

Thank you so much

[@satchijena]

Excellent !!!

[@alionessprincess]

I can barely see the text.. too small!

[@samikariem4298]

DUNK SCHONE

[@Sachinkumar-qg7cp]

Very helpful🫡

[@koserrist6977]

ZA DUZO GADASZ