Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Freeing a Statement Handle

SQL Server 2000

As mentioned earlier, it is more efficient to reuse statement handles than drop them and allocate new ones. Before executing a new Microsoft® SQL Server™ statement on a statement handle, applications should check that the current statement settings are appropriate. These include statement attributes, parameter bindings, and result set bindings. Generally, parameters and result sets for the old SQL statement must be unbound (by calling SQLFreeStmt with the SQL_RESET_PARAMS and SQL_UNBIND options) and rebound for the new SQL statement.

When the application has finished using the statement, it calls SQLFreeHandle to free the statement. Note that SQLDisconnect automatically frees all statements on a connection.

To use a statement


See Also



© 2015 Microsoft