Database.ExecuteNonQuery Database.ExecuteNonQuery Database.ExecuteNonQuery Method

정의

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

오버로드

ExecuteNonQuery(StringCollection) ExecuteNonQuery(StringCollection) ExecuteNonQuery(StringCollection)

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

ExecuteNonQuery(String) ExecuteNonQuery(String) ExecuteNonQuery(String)

어떤 결과도 반환되지 않는 데이터베이스의 컨텍스트에서 문을 실행합니다. Executes a statement in the context of the database where there are no results returned.

ExecuteNonQuery(StringCollection, ExecutionTypes) ExecuteNonQuery(StringCollection, ExecutionTypes) ExecuteNonQuery(StringCollection, ExecutionTypes)

어떤 결과도 반환되지 않는 데이터베이스의 컨텍스트에서 지정한 실행 유형에 대해서만 일괄 처리 컬렉션을 실행합니다. Runs a collection of batches in the context of the database where there are no results returned for the specified execution type only.

ExecuteNonQuery(String, ExecutionTypes) ExecuteNonQuery(String, ExecutionTypes) ExecuteNonQuery(String, ExecutionTypes)

어떤 결과도 반환되지 않는 데이터베이스의 컨텍스트에서 지정한 실행 유형에 대해서만 일괄 처리를 실행합니다. Executes a batch in the context of the database where there are no results returned for the specified execution type only.

ExecuteNonQuery(StringCollection) ExecuteNonQuery(StringCollection) ExecuteNonQuery(StringCollection)

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

public:
 void ExecuteNonQuery(System::Collections::Specialized::StringCollection ^ sqlCommands);
public void ExecuteNonQuery (System.Collections.Specialized.StringCollection sqlCommands);
Public Sub ExecuteNonQuery (sqlCommands As StringCollection)
매개 변수
sqlCommands
StringCollection StringCollection StringCollection

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

예제

'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)  
      }  
   }  
}  

설명

sqlCommands 매개 변수의 StringCollection 값은 여러 명령으로 Transact-SQL 스크립트를 보낼 수 있도록 합니다.The StringCollection value of the sqlCommands parameter makes it possible to send a Transact-SQL script with multiple commands.

ExecuteNonQuery(String) ExecuteNonQuery(String) ExecuteNonQuery(String)

어떤 결과도 반환되지 않는 데이터베이스의 컨텍스트에서 문을 실행합니다. Executes a statement in the context of the database where there are no results returned.

public:
 void ExecuteNonQuery(System::String ^ sqlCommand);
public void ExecuteNonQuery (string sqlCommand);
Public Sub ExecuteNonQuery (sqlCommand As String)
매개 변수
sqlCommand
String String String

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

예제

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)  
      }  
   }  
}  

ExecuteNonQuery(StringCollection, ExecutionTypes) ExecuteNonQuery(StringCollection, ExecutionTypes) ExecuteNonQuery(StringCollection, ExecutionTypes)

어떤 결과도 반환되지 않는 데이터베이스의 컨텍스트에서 지정한 실행 유형에 대해서만 일괄 처리 컬렉션을 실행합니다. Runs a collection of batches in the context of the database where there are no results returned for the specified execution type only.

public:
 void ExecuteNonQuery(System::Collections::Specialized::StringCollection ^ sqlCommands, Microsoft::SqlServer::Management::Common::ExecutionTypes executionType);
public void ExecuteNonQuery (System.Collections.Specialized.StringCollection sqlCommands, Microsoft.SqlServer.Management.Common.ExecutionTypes executionType);
Public Sub ExecuteNonQuery (sqlCommands As StringCollection, executionType As ExecutionTypes)
매개 변수
sqlCommands
StringCollection StringCollection StringCollection

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

executionType
Microsoft.SqlServer.Management.Common.ExecutionTypes Microsoft.SqlServer.Management.Common.ExecutionTypes Microsoft.SqlServer.Management.Common.ExecutionTypes

Microsoft.SqlServer.Management.Common.ExecutionTypes 개체 실행 유형을 지정 하는 값입니다. An Microsoft.SqlServer.Management.Common.ExecutionTypes object value that specifies the execution type.

예제

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)  
      }  
   }  
}  

설명

sqlCommands 매개 변수의 StringCollection 값은 여러 명령으로 Transact-SQL 스크립트를 보낼 수 있도록 합니다.The StringCollection value of the sqlCommands parameter makes it possible to send a Transact-SQL script with multiple commands.

executionType 매개 변수는 실행할 명령 유형을 필터링하는 데 사용됩니다.The executionType parameter is used to filter the types of commands that are run. 예를 들어 <xref:Microsoft.SqlServer.Management.Common.ExecutionTypes.ContinueOnError> 옵션을 사용하여 오류 발생 후 계속 실행되도록 지정할 수 있습니다.For example, you can specify that the execution continue after encountering an error with the <xref:Microsoft.SqlServer.Management.Common.ExecutionTypes.ContinueOnError> option.

ExecuteNonQuery(String, ExecutionTypes) ExecuteNonQuery(String, ExecutionTypes) ExecuteNonQuery(String, ExecutionTypes)

어떤 결과도 반환되지 않는 데이터베이스의 컨텍스트에서 지정한 실행 유형에 대해서만 일괄 처리를 실행합니다. Executes a batch in the context of the database where there are no results returned for the specified execution type only.

public:
 void ExecuteNonQuery(System::String ^ sqlCommand, Microsoft::SqlServer::Management::Common::ExecutionTypes executionType);
public void ExecuteNonQuery (string sqlCommand, Microsoft.SqlServer.Management.Common.ExecutionTypes executionType);
Public Sub ExecuteNonQuery (sqlCommand As String, executionType As ExecutionTypes)
매개 변수
sqlCommand
String String String

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

executionType
Microsoft.SqlServer.Management.Common.ExecutionTypes Microsoft.SqlServer.Management.Common.ExecutionTypes Microsoft.SqlServer.Management.Common.ExecutionTypes

Microsoft.SqlServer.Management.Common.ExecutionTypes 개체 실행 유형을 지정 하는 값입니다. An Microsoft.SqlServer.Management.Common.ExecutionTypes object value that specifies the execution type.

예제

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)  
      }  
   }  
}  

설명

executionType 매개 변수는 실행할 명령 유형을 필터링하는 데 사용됩니다.The executionType parameter is used to filter the types of commands that are run. 예를 들어 <xref:Microsoft.SqlServer.Management.Common.ExecutionTypes.ContinueOnError> 옵션을 사용하여 오류 발생 후 계속 실행되도록 지정할 수 있습니다.For example, you can specify that the execution continue after encountering an error with the <xref:Microsoft.SqlServer.Management.Common.ExecutionTypes.ContinueOnError> option.

적용 대상