| title | Using the OUTPUT Clause with OLE DB in OLE DB Driver for SQL Server | |
|---|---|---|
| description | Learn about using the OUTPUT clause in an INSERT, UPDATE, DELETE, or MERGE command in OLE DB Driver for SQL Server. | |
| author | David-Engel | |
| ms.author | davidengel | |
| ms.date | 06/14/2018 | |
| ms.service | sql | |
| ms.subservice | connectivity | |
| ms.topic | reference | |
| ms.custom |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
If you use an OUTPUT clause in an INSERT, UPDATE, DELETE, or MERGE command, the count of affected rows is not available. The application must count the number of rows in the rowset that is returned by the OUTPUT clause.