TransArticle.ScriptChangeColumnDestinationDataType 方法
Returns a Transact-SQL script used to change the column data type mapping for a non-SQL Server Publisher.
命名空間： Microsoft.SqlServer.Replication
組件： Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)
語法
'宣告
Public Function ScriptChangeColumnDestinationDataType ( _
columnName As String, _
dataType As String, _
precision As Long, _
scale As Integer, _
length As Long, _
scriptOption As ScriptOptions _
) As String
'用途
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
參數
- columnName
型別：System.String
A String value that specifies the name of the column for which the destination data type is changed.
- dataType
型別：System.String
A String value that specifies the data type to which the column is changed.
- precision
型別：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
型別：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
型別：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
型別：Microsoft.SqlServer.Replication.ScriptOptions
A ScriptOptions object value that specifies the scripting options.
傳回值
型別：System.String
A String value that contains a Transact-SQL script.
備註
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.
請參閱
參考
Microsoft.SqlServer.Replication 命名空間