sqlsrv_cancel
sqlsrv_cancel - Cancels a statement
Manual
sqlsrv_cancel(
resource$stmt ): bool
Cancels a statement. Any results associated with the statement that have not been consumed are deleted. After sqlsrv_cancel has been called, the specified statement can be re-executed if it was created with sqlsrv_prepare. Calling sqlsrv_cancel is not necessary if all the results associated with the statement have been consumed.
Parameters
- stmt
-
The statement resource to be cancelled.
Return Values
Returns true on success or false on failure.
Notes
The main difference between sqlsrv_cancel and sqlsrv_free_stmt is that a statement resource cancelled with sqlsrv_cancel can be re-executed if it was created with sqlsrv_prepare. A statement resource cancelled with sqlsrv_free_statement cannot be re-executed.