Earlier I have blogged about SQL SERVER – 7 Questions about OUTPUT Clause Answered and lots of people really liked it. However, I walked into a very unique challenge. There are few people who are only watching the YouTube Videos and there are few only reading the blog post and not watching the video. Finally, I have decided to create another SQL in Sixty Seconds video discussing the OUTPUT clause. In this video, we will discuss 5 questions.
In today’s video, we will be discussing the 5 questions related to the OUTPUT clause.
Here are the questions, which I have discussed in the previous video.
Q 1: Does the OUTPUT clause support UPDATE statements?
Q 2: Does the OUTPUT clause support inserting into @tableVariable?
Q 3: Is it possible to have a trigger on the target table used in the OUTPUT clause?
Q 4: What is the performance impact of using the OUTPUT clause?
Q 5: When was the OUTPUT clause introduced in SQL Server?
Let me know your feedback about the video. If you like my videos, I request you to like, share, comment, and subscribe to these videos. Here is the link to my YouTube Videos.
Reference: Pinal Dave (https://blog.sqlauthority.com)