Database.ExecuteWithResults Database.ExecuteWithResults Database.ExecuteWithResults Method

정의

결과가 반환되는 데이터베이스의 컨텍스트에서 일괄 처리 컬렉션을 실행합니다. Executes a collection of batches in the context of the database where there are results returned.

오버로드

ExecuteWithResults(StringCollection) ExecuteWithResults(StringCollection) ExecuteWithResults(StringCollection)

결과가 반환되는 데이터베이스의 컨텍스트에서 일괄 처리를 실행합니다. Executes a batch in the context of the database where there are results returned.

ExecuteWithResults(String) ExecuteWithResults(String) ExecuteWithResults(String)

결과가 반환되는 데이터베이스의 컨텍스트에서 일괄 처리 컬렉션을 실행합니다. Executes a collection of batches in the context of the database where there are results returned.

ExecuteWithResults(StringCollection) ExecuteWithResults(StringCollection) ExecuteWithResults(StringCollection)

결과가 반환되는 데이터베이스의 컨텍스트에서 일괄 처리를 실행합니다. Executes a batch in the context of the database where there are results returned.

public:
 System::Data::DataSet ^ ExecuteWithResults(System::Collections::Specialized::StringCollection ^ sqlCommands);
public System.Data.DataSet ExecuteWithResults (System.Collections.Specialized.StringCollection sqlCommands);
Public Function ExecuteWithResults (sqlCommands As StringCollection) As DataSet
매개 변수
sqlCommands
StringCollection StringCollection StringCollection

A StringCollection 둘 이상의 Transact 포함 된 시스템 개체 값-SQL 명령입니다. A StringCollection system object value that contains more than one Transact-SQL command.

반환

반환 결과 집합을 포함하는 DataSet 시스템 개체 값입니다. A DataSet system object value that contains the returned results set.

예제

VBVB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Run a Transact-SQL command on the database.  
db.ExecuteNonQuery("CHECKPOINT")  

'Run a Transact-SQL command with results and display.  
Dim ds As DataSet  
ds = db.ExecuteWithResults( _  
"SELECT * FROM Person.Address")  
Dim t As DataTable  
Dim r As DataRow  
Dim c As DataColumn  
For Each t In ds.Tables  
   For Each r In t.Rows  
      For Each c In r.Table.Columns  
          Console.WriteLine( _  
          c.ColumnName + " = " + r(c).ToString)  
      Next  
   Next  
Next  

PowerShellPowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
$db.ExecuteNonQuery("CHECKPOINT")  
$ds = $db.ExecuteWithResults("SELECT * FROM Person.Address")  
Foreach ($t in $ds.Tables)  
{  
   Foreach ($r in $t.Rows)  
   {  
      Foreach ($c in $t.Columns)  
      {  
          Write-Host $c.ColumnName "=" $r.Item($c)  
      }  
   }  
}  

ExecuteWithResults(String) ExecuteWithResults(String) ExecuteWithResults(String)

결과가 반환되는 데이터베이스의 컨텍스트에서 일괄 처리 컬렉션을 실행합니다. Executes a collection of batches in the context of the database where there are results returned.

public:
 System::Data::DataSet ^ ExecuteWithResults(System::String ^ sqlCommand);
public System.Data.DataSet ExecuteWithResults (string sqlCommand);
Public Function ExecuteWithResults (sqlCommand As String) As DataSet
매개 변수
sqlCommand
String String String

A String Transact 포함 된 값-SQL 명령입니다. A String value that contains a Transact-SQL command.

반환

반환 결과 집합을 포함하는 DataSet 시스템 개체 값입니다. A DataSet system object value that contains the returned results set.

예제

VBVB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Run a Transact-SQL command on the database.  
db.ExecuteNonQuery("CHECKPOINT")  

'Run a Transact-SQL command with results and display.  
Dim ds As DataSet  
ds = db.ExecuteWithResults( _  
"SELECT * FROM Person.Address")  
Dim t As DataTable  
Dim r As DataRow  
Dim c As DataColumn  
For Each t In ds.Tables  
   For Each r In t.Rows  
      For Each c In r.Table.Columns  
          Console.WriteLine( _  
          c.ColumnName + " = " + r(c).ToString)  
      Next  
   Next  
Next  

PowerShellPowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
$db.ExecuteNonQuery("CHECKPOINT")  
$ds = $db.ExecuteWithResults("SELECT * FROM Person.Address")  
Foreach ($t in $ds.Tables)  
{  
   Foreach ($r in $t.Rows)  
   {  
      Foreach ($c in $t.Columns)  
      {  
          Write-Host $c.ColumnName "=" $r.Item($c)  
      }  
   }  
}  

설명

이 메서드의 결과는 DataSet 개체로 반환됩니다.The results from this method are returned as a DataSet object. DataSet 개체는 열 및 행 정보를 추출할 수 있는 DataTable 개체의 컬렉션을 포함합니다.The DataSet object contains a collection of DataTable objects, from which the column and row information can be extracted.

적용 대상