Metodo TransArticle.ScriptChangeColumnDestinationDataType

Articolo
02/01/2013

Returns a Transact-SQL script used to change the column data type mapping for a non-SQL Server Publisher.

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

Sintassi

'Dichiarazione
Public Function ScriptChangeColumnDestinationDataType ( _
    columnName As String, _
    dataType As String, _
    precision As Long, _
    scale As Integer, _
    length As Long, _
    scriptOption As ScriptOptions _
) As String
'Utilizzo
Dim instance As TransArticle 
Dim columnName As String 
Dim dataType As String 
Dim precision As Long 
Dim scale As Integer 
Dim length As Long 
Dim scriptOption As ScriptOptions 
Dim returnValue As String 

returnValue = instance.ScriptChangeColumnDestinationDataType(columnName, _
    dataType, precision, scale, length, _
    scriptOption)

public string ScriptChangeColumnDestinationDataType(
    string columnName,
    string dataType,
    long precision,
    int scale,
    long length,
    ScriptOptions scriptOption
)

public:
String^ ScriptChangeColumnDestinationDataType(
    String^ columnName, 
    String^ dataType, 
    long long precision, 
    int scale, 
    long long length, 
    ScriptOptions scriptOption
)

member ScriptChangeColumnDestinationDataType : 
        columnName:string * 
        dataType:string * 
        precision:int64 * 
        scale:int * 
        length:int64 * 
        scriptOption:ScriptOptions -> string

public function ScriptChangeColumnDestinationDataType(
    columnName : String, 
    dataType : String, 
    precision : long, 
    scale : int, 
    length : long, 
    scriptOption : ScriptOptions
) : String

Parametri

columnName
Tipo: System.String
A String value that specifies the name of the column for which the destination data type is changed.

dataType
Tipo: System.String
A String value that specifies the data type to which the column is changed.

precision
Tipo: System.Int64
An Int32 value that specifies the precision of the data type. Set this parameter to -1 if it does not apply to the specified data type.

scale
Tipo: System.Int32
An Int32 value that specifies the scale of the data type. Set this parameter to -1 if it does not apply to the specified data type.

length
Tipo: System.Int64
An Int32 value that specifies the length of the data type. Set this parameter to -1 if it does not apply to the specified data type.

scriptOption
Tipo: Microsoft.SqlServer.Replication.ScriptOptions
A ScriptOptions object value that specifies the scripting options.

Valore restituito

Tipo: System.String
A String value that contains a Transact-SQL script.

Osservazioni

The ScriptChangeColumnDestinationDataType method is only supported for a non-SQL Server Publisher.

The scriptOption parameter specifies what to include in the script. Use Creation to return a creation script. Use Deletion to return a deletion script. Use IncludePublications to include all publications. Use IncludePullSubscriptions to include all pull subscriptions.

Vedere anche

Riferimento

TransArticle Classe

Spazio dei nomi Microsoft.SqlServer.Replication

Altre risorse

Mapping dei tipi di dati per i server di pubblicazione Oracle

Condividi tramite