QueryResults Object (SQL-DMO)

The QueryResults object presents tabular data to the SQL-DMO application. SQL-DMO enumeration methods, such as the EnumLocks method of the Database object, return a QueryResults object to report their data. SQL-DMO statement execution methods, such as the ExecuteWithResults method of Database and SQLServer objects, also return a QueryResults object.

Remarks

The QueryResults object is a reporting tool. All properties of the QueryResults object are read-only. With the QueryResults object, you can:

• Navigate data returned from a server running Microsoft® SQL Server™ as the result of statement execution.
• Retrieve specific data values in a data type usable by your application.
• Get the data result of a statement execution as a delimited string of values.

Methods

Properties