| title | cancel Method (SQLServerStatement) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.reviewer | ||
| ms.technology | connectivity | |
| ms.topic | conceptual | |
| apiname |
|
|
| apilocation |
|
|
| apitype | Assembly | |
| ms.assetid | 276bd9c1-9329-4fc9-9622-ed673c83a12d | |
| author | David-Engel | |
| ms.author | v-daenge |
[!INCLUDEDriver_JDBC_Download]
Cancels the SQL statement that is currently being run by this SQLServerStatement object.
public final void cancel()
This cancel method is specified by the cancel method in the java.sql.Statement interface.
When executing a statement that produces a single large forward-only, read-only result set, you might only be interested in some initial set of rows in the returned result set. In this case, the application might call the cancel method of the associated statement object before closing the result set in order to minimize the processing time needed to discard the remaining unnecessary rows. We recommend considering the tradeoff between the processing time that would be saved and the time and the additional round trip to the server needed to cancel the execution when deciding whether to use this technique or not.