ServerConnection.ExecuteWithResults Method

Definition

Namespace:

Microsoft.SqlServer.Management.Common

Assembly:

Microsoft.SqlServer.ConnectionInfo.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Overloads

ExecuteWithResults(StringCollection)	Executes the T-SQL statements in the StringCollection. An array of DataSets are returned that contain the results for each statement in the StringCollection. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception
ExecuteWithResults(String)	Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception
ExecuteWithResults(String, Boolean)	Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

ExecuteWithResults(StringCollection)

Executes the T-SQL statements in the StringCollection. An array of DataSets are returned that contain the results for each statement in the StringCollection. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

public System.Data.DataSet[] ExecuteWithResults (System.Collections.Specialized.StringCollection sqlCommands);

member this.ExecuteWithResults : System.Collections.Specialized.StringCollection -> System.Data.DataSet[]

Public Function ExecuteWithResults (sqlCommands As StringCollection) As DataSet()

Parameters

sqlCommands

StringCollection

Returns

DataSet[]

ExecuteWithResults(String)

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

public System.Data.DataSet ExecuteWithResults (string sqlCommand);

member this.ExecuteWithResults : string -> System.Data.DataSet

Public Function ExecuteWithResults (sqlCommand As String) As DataSet

Parameters

sqlCommand

String

Returns

DataSet

ExecuteWithResults(String, Boolean)

Executes the T-SQL statements in sqlCommand. A DataSet is returned that contains the results. The Connect() method will be called if the connection with the server is not open. Exceptions: ConnectionFailureException ExecutionFailureExeception

public System.Data.DataSet ExecuteWithResults (string sqlCommand, bool retry);

member this.ExecuteWithResults : string * bool -> System.Data.DataSet

Public Function ExecuteWithResults (sqlCommand As String, retry As Boolean) As DataSet

Parameters

sqlCommand

String

retry

Boolean

Whether we should retry if an exception is thrown during execution

Returns

DataSet