ServerConnection.SqlExecutionModes 属性
获取或设置与服务器的引用连接关联的执行模式。
命名空间: Microsoft.SqlServer.Management.Common
程序集: Microsoft.SqlServer.ConnectionInfo(在 Microsoft.SqlServer.ConnectionInfo.dll 中)
语法
声明
Public Property SqlExecutionModes As SqlExecutionModes
Get
Set
用法
Dim instance As ServerConnection
Dim value As SqlExecutionModes
value = instance.SqlExecutionModes
instance.SqlExecutionModes = value
public SqlExecutionModes SqlExecutionModes { get; set; }
public:
property SqlExecutionModes SqlExecutionModes {
SqlExecutionModes get ();
void set (SqlExecutionModes value);
}
member SqlExecutionModes : SqlExecutionModes with get, set
function get SqlExecutionModes () : SqlExecutionModes
function set SqlExecutionModes (value : SqlExecutionModes)
属性值
类型:Microsoft.SqlServer.Management.Common.SqlExecutionModes
一个 SqlExecutionModes 对象值,该值指定与引用的连接关联的执行模式。
示例
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Set the execution mode to CaptureSql for the connection.
srv.ConnectionContext.SqlExecutionModes = SqlExecutionModes.CaptureSql
'Make a modification to the server that is to be captured.
srv.UserOptions.AnsiNulls = True
srv.Alter()
'Iterate through the strings in the capture buffer and display the captured statements.
Dim s As String
For Each s In srv.ConnectionContext.CapturedSql.Text
Console.WriteLine(s)
Next
'Execute the captured statements.
srv.ConnectionContext.ExecuteNonQuery(srv.ConnectionContext.CapturedSql.Text)
'Revert to immediate execution mode.
srv.ConnectionContext.SqlExecutionModes = SqlExecutionModes.ExecuteSql
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server
$srv.ConnectionContext.SqlExecutionModes = [Microsoft.SqlServer.Management.Common.SqlExecutionModes]::CaptureSql
$srv.UserOptions.AnsiNulls = $TRUE
$srv.Alter()
foreach ($s in $srv.ConnectionContext.CapturedSql.Text)
{
Write-Host $s
}
$srv.ConnectionContext.ExecuteNonQuery($srv.ConnectionContext.CapturedSql.Text)
$srv.ConnectionContext.SqlExecutionModes = [Microsoft.SqlServer.Management.Common.SqlExecutionModes]::ExecuteSql
请参阅
参考
Microsoft.SqlServer.Management.Common 命名空间