ServerConnection.BatchSeparator Property

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

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public Property BatchSeparator As String 
    Get 
    Set
'Usage
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)

Property Value

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

Remarks

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.

Examples

C#

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

PowerShell

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

See Also

Reference

ServerConnection Class

Microsoft.SqlServer.Management.Common Namespace