Метод ExecuteSqlWithResults
Executes a batch of Transact-SQL statements that expects one or more returned results sets on the specified instance of SQL Server.
Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.SmoExtended (в Microsoft.SqlServer.SmoExtended.dll)
Синтаксис
'Декларация
Protected Function ExecuteSqlWithResults ( _
server As Server, _
cmd As String _
) As DataSet
'Применение
Dim server As Server
Dim cmd As String
Dim returnValue As DataSet
returnValue = Me.ExecuteSqlWithResults(server, _
cmd)
protected DataSet ExecuteSqlWithResults(
Server server,
string cmd
)
protected:
DataSet^ ExecuteSqlWithResults(
Server^ server,
String^ cmd
)
member ExecuteSqlWithResults :
server:Server *
cmd:string -> DataSet
protected function ExecuteSqlWithResults(
server : Server,
cmd : String
) : DataSet
Параметры
- server
Тип: Microsoft.SqlServer.Management.Smo. . :: . .Server
A Server object that specifies the instance of SQL Server on which to execute the batch of Transact-SQL statements.
- cmd
Тип: System. . :: . .String
A StringCollection system object that contains the batch of Transact-SQL statements to be executed.
Возвращаемое значение
Тип: System.Data. . :: . .DataSet
A DataSet system object that contains the results sets returned by the executed Transact-SQL command batch.
См. также