ExecuteNonQuery 메서드 (StringCollection)
Executes a batch in the context of the database where there are no results returned.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo.dll의 Microsoft.SqlServer.Smo
구문
‘선언
Public Sub ExecuteNonQuery ( _
sqlCommands As StringCollection _
)
‘사용 방법
Dim instance As Database
Dim sqlCommands As StringCollection
instance.ExecuteNonQuery(sqlCommands)
public void ExecuteNonQuery(
StringCollection sqlCommands
)
public:
void ExecuteNonQuery(
StringCollection^ sqlCommands
)
member ExecuteNonQuery :
sqlCommands:StringCollection -> unit
public function ExecuteNonQuery(
sqlCommands : StringCollection
)
매개 변수
- sqlCommands
형식: System.Collections.Specialized. . :: . .StringCollection
A StringCollection System object value that contains more than one Transact-SQL command.
주의
The StringCollection value of the sqlCommands parameter makes it possible to send a Transact-SQL script with multiple commands.
예제
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'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