hi community, please note that the syntax and explanation shown in the video is for SQL Server , however the syntax changes for mysql .Logic however remains the same.
Thanks for the Amazing Explanation Ankit ❤️ Not not understood correctly, working with triggers could be really challenging 😅 Saying from my personal experience
@ankitbansal6: is it possible to get the information who updated it? could u pls make video who updated the table either his name or user id we should get in seperate column
Do like the video and let me know if any specific topic you want me to cover.
❤❤❤❤❤
👍👍👍👍
Sure,
Topic request to consider - query optimization
Thanks
Sir if possible make a series of interview preparation for SQL beginner to advance series 😊
Please make a video series on store proc ,function ,temp table 🙏
Can you make a long video on stored procedure with different examples plz 🙏🏻 based on interviews or whatever u think its imp
Finally completed these whole trips and tricks playlist, loved it onto the next one.
Ankit Bansal SQL super teaching skills. I love and follow all videos.
I hit like before starting the video...thanks for this long awaited one
Hope you enjoyed it!
@@ankitbansal6 loved it! Could we also please bring a video on parameterized procedures and UDFs?
Wooohooo.. what an amazing day it is .. I wanted to learn about triggers and here it is from the best...❤❤❤
Hope you enjoyed it!
hi community, please note that the syntax and explanation shown in the video is for SQL Server , however the syntax changes for mysql .Logic however remains the same.
Thanks for the Amazing Explanation Ankit ❤️
Not not understood correctly, working with triggers could be really challenging 😅 Saying from my personal experience
for the update trigger...
what if we have more than 100 columns....
do we manually write case statements for each column or is there any other method?
Sir please make a video on Stored Procedure and Index in SQL
very well explained.
Glad you liked it
@ankitbansal6: is it possible to get the information who updated it? could u pls make video who updated the table either his name or user id we should get in seperate column
Yes you can use the username system variable to insert the user name
Best videos sir i want to send email in html table through triggers , so please make video. Only simple table email
Ok I will try
@@ankitbansal6 Thanks lot sir for noted
@@ankitbansal6 yes please sir😊
Use Declare keywords and send an email to customer that the row has been inserted or updated successfully 😊
Please cover package and procedure and functions
Can you please make videos on pyspark
youtube.com/@manish_kumar_1?si=C81OOn7xQPAE9ECa
Follow this channel to learn Pyspark