ServerConnection.ExecuteNonQuery Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| ExecuteNonQuery(StringCollection) | |
| ExecuteNonQuery(String) | |
| ExecuteNonQuery(StringCollection, ExecutionTypes) |
Executes the T-SQL statements in the StringCollection. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches separated with the GO statement will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An array of int values is returned that contain the numbers of rows affected for each statement in the StringCollection. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception |
| ExecuteNonQuery(String, ExecutionTypes) |
Executes a T-SQL statement. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An int value is returned that contain the numbers of rows affected. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception |
| ExecuteNonQuery(StringCollection, ExecutionTypes, Boolean) |
Executes the T-SQL statements in the StringCollection. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches separated with the GO statement will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An array of int values is returned that contain the numbers of rows affected for each statement in the StringCollection. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception |
| ExecuteNonQuery(String, ExecutionTypes, Boolean) |
Executes a T-SQL statement. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An int value is returned that contain the numbers of rows affected. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception |
ExecuteNonQuery(StringCollection)
public int[] ExecuteNonQuery (System.Collections.Specialized.StringCollection sqlCommands);member this.ExecuteNonQuery : System.Collections.Specialized.StringCollection -> int[]Public Function ExecuteNonQuery (sqlCommands As StringCollection) As Integer()Parameters
- sqlCommands
- StringCollection
Returns
Applies to
ExecuteNonQuery(String)
ExecuteNonQuery(StringCollection, ExecutionTypes)
Executes the T-SQL statements in the StringCollection. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches separated with the GO statement will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An array of int values is returned that contain the numbers of rows affected for each statement in the StringCollection. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception
public int[] ExecuteNonQuery (System.Collections.Specialized.StringCollection sqlCommands, Microsoft.SqlServer.Management.Common.ExecutionTypes executionType);member this.ExecuteNonQuery : System.Collections.Specialized.StringCollection * Microsoft.SqlServer.Management.Common.ExecutionTypes -> int[]Public Function ExecuteNonQuery (sqlCommands As StringCollection, executionType As ExecutionTypes) As Integer()Parameters
- sqlCommands
- StringCollection
- executionType
- ExecutionTypes
Returns
Applies to
ExecuteNonQuery(String, ExecutionTypes)
Executes a T-SQL statement. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An int value is returned that contain the numbers of rows affected. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception
public int ExecuteNonQuery (string sqlCommand, Microsoft.SqlServer.Management.Common.ExecutionTypes executionType);member this.ExecuteNonQuery : string * Microsoft.SqlServer.Management.Common.ExecutionTypes -> intPublic Function ExecuteNonQuery (sqlCommand As String, executionType As ExecutionTypes) As IntegerParameters
- sqlCommand
- String
- executionType
- ExecutionTypes
Returns
Applies to
ExecuteNonQuery(StringCollection, ExecutionTypes, Boolean)
Executes the T-SQL statements in the StringCollection. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches separated with the GO statement will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An array of int values is returned that contain the numbers of rows affected for each statement in the StringCollection. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception
public int[] ExecuteNonQuery (System.Collections.Specialized.StringCollection sqlCommands, Microsoft.SqlServer.Management.Common.ExecutionTypes executionType, bool retry);member this.ExecuteNonQuery : System.Collections.Specialized.StringCollection * Microsoft.SqlServer.Management.Common.ExecutionTypes * bool -> int[]Public Function ExecuteNonQuery (sqlCommands As StringCollection, executionType As ExecutionTypes, retry As Boolean) As Integer()Parameters
- sqlCommands
- StringCollection
- executionType
- ExecutionTypes
- retry
- Boolean
Whether we should retry if an exception is thrown during execution
Returns
Applies to
ExecuteNonQuery(String, ExecutionTypes, Boolean)
Executes a T-SQL statement. The command termininator ('GO') is recognized by ExecuteNonQuery. Batches will be sent and executed individually. The statement is recorded and not executed if CaptureMode has been set to true. An int value is returned that contain the numbers of rows affected. If multiple batches are executed, the total numbers of affected rows of all batches is returned. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception
public int ExecuteNonQuery (string sqlCommand, Microsoft.SqlServer.Management.Common.ExecutionTypes executionType, bool retry);member this.ExecuteNonQuery : string * Microsoft.SqlServer.Management.Common.ExecutionTypes * bool -> intPublic Function ExecuteNonQuery (sqlCommand As String, executionType As ExecutionTypes, retry As Boolean) As IntegerParameters
- sqlCommand
- String
- executionType
- ExecutionTypes
- retry
- Boolean
Whether we should retry if an exception is thrown during execution