ResultSets Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The ResultSets property returns the count of units of data returned from query execution.
구문
object
.ResultSets
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetResultSets(LPLONG pRetVal);
주의
Commonly, Microsoft SQL Server query execution returns data to the client. Returned data may be an indicator of rows affected by the query, or it can be row data extracted from one or more SQL Server tables. When row data is returned, data is tabular and values in the resulting data can be referenced using ordinal column and row values.
The execution output of some SQL Server queries cannot be represented in a single result unit. For example, each statement in a batch of Transact-SQL statements may return a count of affected rows or row data. Some Transact-SQL statements return multiple units of data, for example, a SELECT statement containing a COMPUTE or COMPUTE BY clause. Each discrete unit of returned data is called a result set.
Use the ResultSets property to determine the number of units of returned data. Use the CurrentResultSet property to navigate between units.
[!참고]
There is no guarantee of consistency between result sets. Each result set may have zero or more columns. Within each set, the names, data types, and meanings of the columns may vary.