executeUpdate Method (java.lang.String, int)

Article
11/18/2022

Runs the given SQL statement and signals the Microsoft JDBC Driver for SQL Server with the given flag about whether the auto-generated keys that are produced by this SQLServerStatement object should be made available for retrieval.

Syntax

  
public final int executeUpdate(java.lang.String sql,  
                               int flag)

Parameters

sql

A String that contains an SQL statement.

flag

An int value that indicates if auto-generated keys should be made available. It must be one of the following constants:

RETURN_GENERATED_KEYS

NO_GENERATED_KEYS

Return Value

An int that indicates the number of rows affected, or 0 if using a DDL statement.

Exceptions

SQLServerException

Remarks

This executeUpdate method is specified by the executeUpdate method in the java.sql.Statement interface.

If executing a stored procedure results in an update count that is greater than one, or that generates more than one result set, use the execute method to execute the stored procedure.