--- title: "prepareStatement Method (java.lang.String, java.lang.String) | 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: - "SQLServerConnection.prepareStatement" apilocation: - "sqljdbc.jar" apitype: "Assembly" ms.assetid: e0db2871-3a5f-4fcc-af61-92333042dcd1 author: David-Engel ms.author: v-daenge --- # prepareStatement Method (java.lang.String, java.lang.String) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Creates a [SQLServerPreparedStatement](../../../connect/jdbc/reference/sqlserverpreparedstatement-class.md) object for sending parameterized SQL statements to the database. ## Syntax ``` public java.sql.PreparedStatement prepareStatement(java.lang.String sql, java.lang.String[] columnNames) ``` #### Parameters *sql* A **String** containing an SQL statement. *columnNames* A **String** array of column names. ## Return Value A PreparedStatement object. ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This prepareStatement method is specified by the prepareStatement method in the java.sql.Connection interface. ## See Also [prepareStatement Method (SQLServerConnection)](../../../connect/jdbc/reference/preparestatement-method-sqlserverconnection.md) [SQLServerConnection Members](../../../connect/jdbc/reference/sqlserverconnection-members.md) [SQLServerConnection Class](../../../connect/jdbc/reference/sqlserverconnection-class.md)