Tag: MERGE with OUTPUT

OUTPUT OPTION
T-SQL supports an OUTPUT clause for modification statements, which we can use to return information from modified rows.
We can use OUTPUT clause with update, insert, delete statements.
UPDATE with OUTPUT:
With the use of OUTPUT option in update statement we have access to both the old data and