| title | SQL Server Message Results | Microsoft Docs | |||
|---|---|---|---|---|
| description | SQL Server message results | |||
| ms.custom | ||||
| ms.date | 06/14/2018 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |||
| ms.reviewer | ||||
| ms.technology | connectivity | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
|||
| author | pmasl | |||
| ms.author | pelopes |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
[!INCLUDEDriver_OLEDB_Download]
The following [!INCLUDEtsql] statements do not generate OLE DB Driver for SQL Server rowsets or a count of affected rows when executed:
-
PRINT
-
RAISERROR with a severity of 10 or lower
-
DBCC
-
SET SHOWPLAN
-
SET STATISTICS
These statements either return one or more informational messages or cause [!INCLUDEssNoVersion] to return informational messages in place of rowset or count results. On successful execution, the OLE DB Driver for SQL Server returns S_OK, and the messages are available to the OLE DB Driver for SQL Server consumer.
The OLE DB Driver for SQL Server returns S_OK and has one or more informational messages available following the execution of many [!INCLUDEtsql] statements or the consumer execution of an OLE DB Driver for SQL Server member function.
The OLE DB Driver for SQL Server consumer allowing dynamic specification of query text should check error interfaces after every member function execution regardless of the value of the return code, the presence or absence of a returned IRowset or IMultipleResults interface reference, or a count of affected rows.