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)