sqlsrv_cancel

(No version information available, might only be in Git)

sqlsrv_cancel — Cancels a statement

Description

boolsqlsrv_cancel
( resource$stmt
)

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.

echo "$count sales accounted for the first $$salesTotal in revenue.<br />";

// Cancel the pending results. The statement can be reused.sqlsrv_cancel( $stmt);?>

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.