Makale
07/26/2011

sp_getdefaultdatatypemapping (Transact-SQL)

Returns information on the default mapping for the specified data type between Microsoft SQL Server and a non-SQL Server database management system (DBMS).Bu saklı yordam, herhangi bir veritabanı üzerinde dağıtımcı adresindeki yürütülür.

Konu bağlantısı simgesi Transact-sql sözdizimi kuralları

Sözdizimi

sp_getdefaultdatatypemapping [ @source_dbms = ] 'source_dbms' 
    [ , [ @source_version = ] 'source_version' ]
        , [ @source_type = ] 'source_type'  
    [ , [ @source_length = ] source_length ]
    [ , [ @source_precision = ] source_precision ]
    [ , [ @source_scale = ] source_scale ]
    [ , [ @source_nullable = ] source_nullable ]
        , [ @destination_dbms = ] 'destination_dbms' 
    [ , [ @destination_version = ] 'destination_version' ]
    [ , [ @destination_type = ] 'destination_type' OUTPUT ]
    [ , [ @destination_length = ] destination_length OUTPUT ]
    [ , [ @destination_precision = ] destination_precision OUTPUT ]
    [ , [ @destination_scale = ] destination_scale OUTPUT ]
    [ , [ @destination_nullable = ] source_nullable OUTPUT ]
    [ , [ @dataloss = ] dataloss OUTPUT ]

Bağımsız değişkenler

[ @ source_dbms=] 'source_dbms'
Is the name of the DBMS from which the data types are mapped.source_dbms is sysname, and can be one of the following values:

Değer

Açıklama

MSSQLSERVER

kaynak SQL Server veritabanı.

ORACLE

kaynak Oracle veritabanıdır.

Bu parametre belirtmelisiniz.
[ @source_version= ] 'source_version'
Is the version number of the source DBMS.source_version is varchar(10), with a default value of NULL.
[ @ source_type=] 'source_type'
Is the data type in the source DBMS.source_type is sysname, with no default.
[ @source_length= ] source_length
Is the length of the data type in the source DBMS.source_length is bigint, with a default value of NULL.
[ @source_precision= ] source_precision
Is the precision of the data type in the source DBMS.source_precision is bigint, with a default value of NULL.
[ @source_scale= ] source_scale
Is the scale of the data type in the source DBMS.source_scale is int, with a default value of NULL.
[ @source_nullable= ] source_nullable
Is if the data type in the source DBMS supports a value of NULL.source_nullable is bit, with a default value of 1, which means that NULL values are supported.

Değer	Açıklama
MSSQLSERVER	kaynak SQL Server veritabanı.
ORACLE	kaynak Oracle veritabanıdır.

[ @ destination_dbms =] 'destination_dbms'
Is the name of the destination DBMS.destination_dbms is sysname, and can be one of the following values:

Değer	Açıklama
MSSQLSERVER	Hedef bir SQL Server veritabanı.
ORACLE	Hedef, bir Oracle veritabanıdır.
DB2	Hedef bir IBM DB2 veritabanıdır.
SYBASE	Hedef Sybase veritabanıdır.

Bu parametre belirtmelisiniz.

[ @ destination_version=] 'destination_version'
Is the product version of the destination DBMS.destination_version is varchar(10), with a default value of NULL.
[ @ destination_type=] 'destination_type' çıktı
Is the data type listed in the destination DBMS.destination_type is sysname, with a default value of NULL.
[ @destination_length= ] destination_length OUTPUT
Is the length of the data type in the destination DBMS.destination_length is bigint, with a default value of NULL.
[ @destination_precision= ] destination_precision OUTPUT
Is the precision of the data type in the destination DBMS.destination_precision is bigint, with a default value of NULL.
[ @destination_scale= ] destination_scaleOUTPUT
Is the scale of the data type in the destination DBMS.destination_scale is int, with a default value of NULL.
[ @destination_nullable= ] destination_nullableOUTPUT
Is if the data type in the destination DBMS supports a value of NULL.destination_nullable is bit, with a default value of NULL.1 null değerleri desteklenir anlamına gelir.
[ @dataloss= ] datalossOUTPUT
Is if the mapping has the potential for data loss.dataloss is bit, with a default value of NULL.1 bir potansiyel veri kaybı olduğunu gösterir.