Condividi tramite

  • Articolo

Proprietà BatchSeparator

Gets or sets the string value used to separate batches in the referenced connection.

Spazio dei nomi  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Sintassi

'Dichiarazione
Public Property BatchSeparator As String
    Get
    Set
'Utilizzo
Dim instance As ServerConnection
Dim value As String

value = instance.BatchSeparator

instance.BatchSeparator = value

public string BatchSeparator { get; set; }

public:
property String^ BatchSeparator {
    String^ get ();
    void set (String^ value);
}

member BatchSeparator : string with get, set

function get BatchSeparator () : String
function set BatchSeparator (value : String)

Valore proprietà

Tipo: System. . :: . .String
A String value that specifies the batch separator for the referenced connection. The default value is "GO".

Osservazioni

The batch separator string contains a word that separates SQL statements into batches, typically "GO". This word is added if the NoCommandTerminator property is set to false.

Esempi

C#

ServerConnection conn = new ServerConnection();
Console.WriteLine(conn.BatchSeparator);

PowerShell

$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
Write-Host $conn.BatchSeparator