Mass Ingestion
- Mass Ingestion
- 所有产品
SQL Serverソースデータ型
| SQL Serverターゲットデータ型
|
---|---|
bigint
| bigint
|
binary
| varbinary
|
bit
| bit
|
char
| varchar
|
date
| date
|
datetime
| datetime
|
datetime2
| datetime2
|
datetimeoffset
| datetimeoffset
|
decimal
| decimal
|
float
| float
|
geography
| geography
|
geometry
| geometry
|
hierarchyid
| hierarchyid
|
image
| image
|
int
| int
|
money
| money
|
nchar
| nvarchar
|
ntext
| ntext
|
numeric
| numeric
|
nvarchar
| nvarchar
|
real
| real
|
smalldatetime
| smalldatetime
|
smallint
| smallint
|
smallmoney
| smallmoney
|
sql_variant
| sql_variant
|
text
| text
|
time
| time
|
timestamp
| varbinary
|
tinyint
| tinyint
|
uniqueidentifier
| uniqueidentifier
|
varbinary
| varbinary
|
varchar
| varchar
|
xml
| xml
|
SELECT <column_name>, CONVERT(varbinary,<column_name>) from <table_name>;