다음을 통해 공유

  • 아티클

ExecuteWithResults 메서드 (String)

결과가 반환되는 데이터베이스의 컨텍스트에서 일괄 처리 컬렉션을 실행합니다.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Function ExecuteWithResults ( _
    sqlCommand As String _
) As DataSet
‘사용 방법
Dim instance As Database
Dim sqlCommand As String
Dim returnValue As DataSet

returnValue = instance.ExecuteWithResults(sqlCommand)

public DataSet ExecuteWithResults(
    string sqlCommand
)

public:
DataSet^ ExecuteWithResults(
    String^ sqlCommand
)

member ExecuteWithResults : 
        sqlCommand:string -> DataSet 

public function ExecuteWithResults(
    sqlCommand : String
) : DataSet

매개 변수

반환 값

유형: System.Data. . :: . .DataSet
반환 결과 집합을 포함하는 DataSet 시스템 개체 값입니다.

주의

The results from this method are returned as a DataSet object. The DataSet object contains a collection of DataTable objects, from which the column and row information can be extracted.

예

VB

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

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

'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

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$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)
      }
   }
}