共用方式為

  • 發行項

SqlExecutionModes 屬性

Gets or sets the execution mode associated with the referenced connection to the server.

命名空間：  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
A SqlExecutionModes object value that specifies the execution mode associated with the referenced connection.

範例

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