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.

[monicacastillo]

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

[beardboyphotography]

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

[TheBIHARIS]

Thanks for the complete step-by-step explanation.

[hafizarahman]

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

[longle]

Thanks Lisa, This really helped me out.

[omotayoogunnika]

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

[jasonmichaelalunan]

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

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

[umutogur]

Thank you so much for your useful video.

[praji]

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

[gunavamshi]

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

[ibrahimhussain]

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;

[neyon]

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

[radoslavdimitrov]

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?

[TecnologySoft]

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

[grk]

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

[S]

Good video but the sound quality lets it down.

[nedu]

How did you come up with CustomerLogs?

[lionessprincess]

I can barely see the text.. too small!