COMPUTE Clause and Multiple Result Sets

The compute sample illustrates handling the multiple result sets that occur when an application executes a Transact-SQL SELECT statement containing a COMPUTE clause.

The sample executes a statement, and then uses SQLMoreResults and SQLColAttribute to determine the shape of each result set generated.

The sample shows how to mix array and single-row binding for rapid and space-efficient handling of the output.

Before compiling the compute sample, open the project and locate these lines in compute.cpp:

PTSTR       szDataSource = _T("MyDatasource");

PTSTR       szUID = _T("MyUID");

PTSTR       szPWD = _T("MyPwd");

Replace the strings:

• MyDatasource with the name of an ODBC datasource that has the Northwind sample database as its default database.
• MyUID with a valid login ID.
• MyPwd with the password for the login specified for szUID.

After compiling and linking the sample, run it by specifying its name at the command prompt:

cd C:\Mssql7\Devtools\Samples\ODBC\Compute\Release compute

Build Configurations

Compute.mak contains nmake configurations for ANSI and Unicode debug and release versions of the sample.

Functions Illustrated