QueryResults Object

QueryResults Object Properties Methods Collections

Description

A QueryResults object contains the result set from an executed Transact-SQL query. All EnumItems list methods return a QueryResults object. The ExecuteWithResults method of the SQLServer, Database, and RemoteServer objects also returns a QueryResults object. The query results returned from SQL Server are stored in memory and cannot be changed.

To retrieve data from a specific result set, set the CurrentResultSet property to the desired result set. Then call the desired GetColumnDatatype method to get a value from a single column of a single row, or call the GetRangeString method to return a block of row and column data.