Redigera

Dela via


Assigning Storage

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

An application can assign storage for results before or after it executes a SQL statement. If an application prepares or executes the SQL statement first, it can inquire about the result set before it assigns storage for results. For example, if the result set is unknown, the application must retrieve the number of columns before it can assign storage for them.

To associate storage for a column of data, an application calls SQLBindCol and passes it:

  • The data type to which the data is to be converted.

  • The address of an output buffer for the data.

    The application must allocate this buffer, and it must be large enough to hold the data in the form to which it is converted.

  • The length of the output buffer.

    This value is ignored if the returned data has a fixed width in C, such as an integer, real number, or date structure.

  • The address of a storage buffer in which to return the number of bytes of available data.

An application can also bind result set columns to arrays of program variables to support fetching result set rows in blocks. There are two different types of array binding:

  • Column-wise binding is finished when each column is bound to its own array of variables.

    Column-wise binding is specified by calling SQLSetStmtAttr with Attribute set to SQL_ATTR_ROW_BIND_TYPE and ValuePtr set to SQL_BIND_BY_COLUMN. All the arrays must have the same number of elements.

  • Row-wise binding is finished when all the parameters in the SQL statement are bound as a unit to an array of structures that contain the individual variables for the parameters.

    Row-wise binding is specified by calling SQLSetStmtAttr with Attribute set to SQL_ATTR_ROW_BIND_TYPE and ValuePtr set to the size of the structure holding the variables that will receive the result set columns.

The application also sets SQL_ATTR_ROW_ARRAY_SIZE to the number of elements in the column or row arrays and sets SQL_ATTR_ROW_STATUS_PTR and SQL_ATTR_ROWS_FETCHED_PTR.

See Also

Processing Results (ODBC)