A server with server class mssodbc is Microsoft SQL Server version 6.5, Service Pack 4.
CREATE EXISTING TABLE accounts, AT 'mymssql.database.owner.accounts';
SAP Sybase IQ Data Type | Microsoft SQL Server Default Data Type |
---|---|
BIT | bit |
TINYINT | tinyint |
SMALLINT | smallint |
INT | int |
BIGINT | numeric(20,0) |
DECIMAL [defaults p=30, s=6] | decimal(prec, scale) |
NUMERIC [defaults p=30 s=6] | numeric(prec, scale) |
FLOAT | if (prec) float(prec) else float |
REAL | real |
SMALLMONEY | smallmoney |
MONEY | money |
DATE | datetime |
TIME | datetime |
TIMESTAMP | datetime |
SMALLDATETIME | datetime |
DATETIME | datetime |
CHAR(n) | if (length > 255) text else varchar(length) |
CHARACTER(n) | char(n) |
VARCHAR(n) | if (length > 255) text else varchar(length) |
LONG VARCHAR | text |
BINARY(n) | if (length > 255) image else binary(length) |
LONG BINARY | image |
DOUBLE | float |
UNIQUEIDENTIFIERSTR | uniqueidentifier |