The Inserted Table is used to store copies of rows affected by the INSERT and UPDATE statements. In an insert or update transaction, the new row is added to both the inserted Table and the trigger table.
The Inserted Table is used to store copies of rows affected by the INSERT and UPDATE statements. In an insert or update transaction, the new row is added to both the inserted Table and the trigger table.
The rows in the Inserted Table are copies of the new rows in the trigger table.
Syntax
Returns all columns.
Insert into [tableName] ([columnName1], [columnNameN],...) OUTPUT inserted. * VALUES ('value1 ', 'value2 ',...)
Returns the specified column.
Insert into [tableName] ([columnName1], [columnNameN],...) OUTPUT inserted. [columnName] VALUES ('value1 ', 'value2 ',...)
You can use vo or dataset to obtain data, just like normal SELECT statements.
