Output clause in SQL Server - Part 28
Subscribe to IT PORT : / itport28
SQL Server Tutorial in Tamil : • SQL Server Tutorial in Tamil
SQL Server Concepts in Tamil : • SQL Server Concepts in Tamil
SQL Server Analytic Functions in Tamil : • SQL Server Analytic Functions Tamil
SQL Server Tutorial : • SQL Server Tutorial
SQL Server Concepts : • SQL Server Concepts
SQL Server Analytic Functions : • SQL Server Analytic Functions
OUTPUT Clause is used to returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements.
The results can also be inserted into a table or table variable. Additionally, you can capture the results of an OUTPUT clause in a nested INSERT, UPDATE, DELETE, or MERGE statement, and insert those results into a target table or view.