Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaySQLFreeHandle
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
In manual-commit mode, calling SQLFreeHandle on a statement handle with an open transaction causes a rollback of pending changes to the database. Calling SQLFreeHandle on a statement handle always closes any open cursors and discards pending results, freeing all resources associated with the statement handle.