Edit

executeUpdate Method (java.lang.String) (SQLServerStatement)

Download JDBC driver

Runs the given SQL statement, which can be an INSERT, UPDATE, or DELETE statement; or a SQL statement that returns nothing, such as a SQL DDL statement. Beginning in Microsoft SQL Server JDBC Driver 3.0, executeUpdate will return the correct number of rows updated in a MERGE operation.

Syntax

  
public int executeUpdate(java.lang.String sql)  

Parameters

sql

A String that contains the SQL statement.

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.