Partager via

  • Article

SqlExecutionModes propriété

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

Espace de noms :  Microsoft.SqlServer.Management.Common
Assembly :  Microsoft.SqlServer.ConnectionInfo (dans Microsoft.SqlServer.ConnectionInfo.dll)

Syntaxe

'Déclaration
Public Property SqlExecutionModes As SqlExecutionModes
    Get
    Set
'Utilisation
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)

Valeur de la propriété

Type : Microsoft.SqlServer.Management.Common. . :: . .SqlExecutionModes
A SqlExecutionModes object value that specifies the execution mode associated with the referenced connection.

Exemples

'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