Condividi tramite


Proprietà SnapshotGenerationAgent.FieldDelimiter

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

Spazio dei nomi  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)

Sintassi

'Dichiarazione
Public Property FieldDelimiter As String 
    Get 
    Set
'Utilizzo
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)

Valore proprietà

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

Implementa

ISnapshotGenerationAgent.FieldDelimiter

Osservazioni

When the FieldDelimiter property is set to nullriferimento Null (Nothing in 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.

Vedere anche

Riferimento

SnapshotGenerationAgent Classe

Spazio dei nomi Microsoft.SqlServer.Replication