Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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