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!!

[@omotayoogunnika6865]

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

[@TheBIHARIS]

Thanks for the complete step-by-step explanation.

[@hafizarahman9999]

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

[@skdonsingh]

Thank you ma'am
It was nice explanation.

[@monicacastillo1183]

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

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

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

[@john_yeager]

very nice example thanks

[@umutogur391]

Thank you so much for your useful video.

[@jasonmichaelalunan2492]

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

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

[@fealgu100]

Thanks, Lisa!

[@longle7603]

Thanks Lisa, This really helped me out.

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

[@TecnologySoft]

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

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

[@vaitheesvaranv4108]

Thank you so much

[@solodevelopersolo]

Amazing work

[@bc-ei4nc]

amazing video !!!! Thanks!

[@leroypalmer9226]

Great video!

[@nedu47]

How did you come up with CustomerLogs?

[@michaeljames4440]

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

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

[@satchijena]

Excellent !!!

[@S2100211]

Good video but the sound quality lets it down.

[@Sachinkumar-qg7cp]

Very helpful🫡

[@gotchihaeyo1825]

It's very hard to see and read

[@samikariem4298]

DUNK SCHONE

[@koserrist6977]

ZA DUZO GADASZ

[@avictoriouswarrior]

I can barely see the text.. too small!