| title | OUTPUT clause, OLE DB |
|---|---|
| description | Using the OUTPUT Clause with OLE DB in SQL Server Native Client |
| author | markingmyname |
| ms.author | maghan |
| ms.date | 03/03/2017 |
| ms.service | sql |
| ms.subservice | native-client |
| ms.topic | reference |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
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.
Creating a SQL Server Native Client OLE DB Provider Application