• Artigo

Propriedade do RDL FieldDelimiter

Gets or sets the character or character sequence that marks the end of a field in the SQL Server bulk-copy data file.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (em Microsoft.SqlServer.Replication.dll)

Sintaxe

'Declaração
Public Property FieldDelimiter As String
    Get
    Set
'Uso
Dim instance As SnapshotGenerationAgent
Dim value As String

value = instance.FieldDelimiter

instance.FieldDelimiter = value

public string FieldDelimiter { get; set; }

public:
virtual property String^ FieldDelimiter {
    String^ get () sealed;
    void set (String^ value) sealed;
}

abstract FieldDelimiter : string with get, set
override FieldDelimiter : string with get, set

final function get FieldDelimiter () : String
final function set FieldDelimiter (value : String)

Valor da propriedade

Tipo: System. . :: . .String
A String value that represents the field delimiter.

Implementa

ISnapshotGenerationAgent. . :: . .FieldDelimiter

Comentários

When the FieldDelimiter property is set to null Nothing nullptr unit uma referência nula (Nothing no Visual Basic) or an empty string value, the default delimiter \n<x$3>\n is used.

When setting FieldDelimiter, it is important to choose a delimiter value that will never be included in part of any published data value or else there will be ambiguity as to where data is delimited when the generated bcp file is applied to the Subscriber.