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.

Related content

• executeUpdate Method (SQLServerStatement)
• SQLServerStatement Members
• SQLServerStatement Class