共用方式為

TransArticle.SetColumnDestinationDataType Method

  • 發行項

Sets the column data type mapping for a non-SQL Server Publisher.

命名空間: Microsoft.SqlServer.Replication
組件: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

語法

'宣告
Public Sub SetColumnDestinationDataType ( _
    columnName As String, _
    dataType As String, _
    precision As Long, _
    scale As Integer, _
    length As Long _
)

public void SetColumnDestinationDataType (
    string columnName,
    string dataType,
    long precision,
    int scale,
    long length
)

public:
void SetColumnDestinationDataType (
    String^ columnName, 
    String^ dataType, 
    long long precision, 
    int scale, 
    long long length
)

public void SetColumnDestinationDataType (
    String columnName, 
    String dataType, 
    long precision, 
    int scale, 
    long length
)

public function SetColumnDestinationDataType (
    columnName : String, 
    dataType : String, 
    precision : long, 
    scale : int, 
    length : long
)

參數

  • columnName
    A String value that specifies the name of the column for which the destination data type is changed.
  • dataType
    A String value that specifies the data type to which the column is changed.
  • precision
    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
    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
    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.

備註

The SetColumnDestinationDataType method is only supported for non-SQL Server Publishers.

The SetColumnDestinationDataType method can only be called by members of the sysadmin fixed server role at the Distributor or by members of the db_owner fixed database role on the database.

Calling SetColumnDestinationDataType is equivalent to executing sp_changearticlecolumndatatype.

The SetColumnDestinationDataType method is only available when working with instances of SQL Server 2005 or later.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

TransArticle Class
TransArticle Members
Microsoft.SqlServer.Replication Namespace

其他資源

Oracle 發行者的資料類型對應