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.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
