Inserting data returned from an output clause The following example captures data returned from the output clause of a merge statement, and inserts that data into another table.Indicates the approximate number of rows of data in the binary data stream.

Use the opendatasource function to specify the remote data source.A null value is used.

The insert statement is always fully logged except when using the openrowset function with the bulk keyword or when using insert into target_table select columns from source_table.The merge statement updates the Quantity column of the ProductInventory table daily, based on orders that are processed in the SalesOrderDetail table in the AdventureWorks2012 database.dml_table_source Specifies that the rows inserted into the target table are those returned by the output clause of an insert, update, delete, or merge statement, optionally filtered by a where clause.