📄 describecol.in

📁 在Linux/Unix下面访问WINDOWS SQLSERVER 的ODBC驱动程序
💻 IN
字号:
# test all types using ODBC 2select bit 0attr SQL_COLUMN_LENGTH 1attr SQL_COLUMN_PRECISION 1attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 1attr SQL_DESC_OCTET_LENGTH 1attr SQL_DESC_PRECISION 1attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 1select tinyint 0attr SQL_COLUMN_LENGTH 1attr SQL_COLUMN_PRECISION 3attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 3attr SQL_DESC_OCTET_LENGTH 1attr SQL_DESC_PRECISION 3attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 3select smallint 0attr SQL_COLUMN_LENGTH 2attr SQL_COLUMN_PRECISION 5attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 5attr SQL_DESC_OCTET_LENGTH 2attr SQL_DESC_PRECISION 5attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 6select int 0attr SQL_COLUMN_LENGTH 4attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 4attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 11select bigint 0attr SQL_COLUMN_LENGTH 8attr SQL_COLUMN_PRECISION 19attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 19attr SQL_DESC_OCTET_LENGTH 8attr SQL_DESC_PRECISION 19attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 20select real 0attr SQL_COLUMN_LENGTH 4attr SQL_COLUMN_PRECISION 7attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 7attr SQL_DESC_OCTET_LENGTH 4attr SQL_DESC_PRECISION 7attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 14select float 0attr SQL_COLUMN_LENGTH 8attr SQL_COLUMN_PRECISION 15attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 15attr SQL_DESC_OCTET_LENGTH 8attr SQL_DESC_PRECISION 15attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 24select smallmoney 0attr SQL_COLUMN_LENGTH 12attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 4attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 12attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 4attr SQL_DESC_DISPLAY_SIZE 12select money 0attr SQL_COLUMN_LENGTH 21attr SQL_COLUMN_PRECISION 19attr SQL_COLUMN_SCALE 4attr SQL_DESC_LENGTH 19attr SQL_DESC_OCTET_LENGTH 21attr SQL_DESC_PRECISION 19attr SQL_DESC_SCALE 4attr SQL_DESC_DISPLAY_SIZE 21select numeric(10,2) 0attr SQL_COLUMN_LENGTH 12attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 2attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 12attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 2attr SQL_DESC_DISPLAY_SIZE 12select numeric(23,4) 0attr SQL_COLUMN_LENGTH 25attr SQL_COLUMN_PRECISION 23attr SQL_COLUMN_SCALE 4attr SQL_DESC_LENGTH 23attr SQL_DESC_OCTET_LENGTH 25attr SQL_DESC_PRECISION 23attr SQL_DESC_SCALE 4attr SQL_DESC_DISPLAY_SIZE 25select datetime '2006-04-14'attr SQL_COLUMN_LENGTH 16attr SQL_COLUMN_PRECISION 23attr SQL_COLUMN_SCALE 3attr SQL_DESC_LENGTH 23attr SQL_DESC_OCTET_LENGTH 16attr SQL_DESC_PRECISION 3attr SQL_DESC_SCALE 3attr SQL_DESC_DISPLAY_SIZE 23select smalldatetime '2006-04-14'attr SQL_COLUMN_LENGTH 16attr SQL_COLUMN_PRECISION 16attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 16attr SQL_DESC_OCTET_LENGTH 16attr SQL_DESC_PRECISION 0attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 19select char(10) 'hi!'attr SQL_COLUMN_LENGTH 10attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 10attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 10select varchar(11) 'hi!'attr SQL_COLUMN_LENGTH 11attr SQL_COLUMN_PRECISION 11attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 11attr SQL_DESC_OCTET_LENGTH 11attr SQL_DESC_PRECISION 11attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 11select nchar(12) 'hi!'## TODO#attr SQL_COLUMN_LENGTH 24attr SQL_COLUMN_PRECISION 12attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 12## TODO#attr SQL_DESC_OCTET_LENGTH 24attr SQL_DESC_PRECISION 12attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 12select nvarchar(13) 'hi!'## TODO#attr SQL_COLUMN_LENGTH 26attr SQL_COLUMN_PRECISION 13attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 13## TODO#attr SQL_DESC_OCTET_LENGTH 26attr SQL_DESC_PRECISION 13attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 13select text 'hi!'attr SQL_COLUMN_LENGTH 4096attr SQL_COLUMN_PRECISION 4096attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 4096attr SQL_DESC_OCTET_LENGTH 4096attr SQL_DESC_PRECISION 4096attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 4096select ntext 'hi!'## TODO#attr SQL_COLUMN_LENGTH 4096attr SQL_COLUMN_PRECISION 2048attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 2048## TODO#attr SQL_DESC_OCTET_LENGTH 4096attr SQL_DESC_PRECISION 2048attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 2048select binary(10) 'hi!'attr SQL_COLUMN_LENGTH 10attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 10attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 20select varbinary(11) 'hi!'attr SQL_COLUMN_LENGTH 11attr SQL_COLUMN_PRECISION 11attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 11attr SQL_DESC_OCTET_LENGTH 11attr SQL_DESC_PRECISION 11attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 22select image 'hi!'attr SQL_COLUMN_LENGTH 4096attr SQL_COLUMN_PRECISION 4096attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 4096attr SQL_DESC_OCTET_LENGTH 4096attr SQL_DESC_PRECISION 4096attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 8192# test all types using ODBC 3odbc 3select bit 0attr SQL_COLUMN_LENGTH 1attr SQL_COLUMN_PRECISION 1attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 1attr SQL_DESC_OCTET_LENGTH 1attr SQL_DESC_PRECISION 1attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 1select tinyint 0attr SQL_COLUMN_LENGTH 1attr SQL_COLUMN_PRECISION 3attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 3attr SQL_DESC_OCTET_LENGTH 1attr SQL_DESC_PRECISION 3attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 3select smallint 0attr SQL_COLUMN_LENGTH 2attr SQL_COLUMN_PRECISION 5attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 5attr SQL_DESC_OCTET_LENGTH 2attr SQL_DESC_PRECISION 5attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 6select int 0attr SQL_COLUMN_LENGTH 4attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 4attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 11select bigint 0attr SQL_COLUMN_LENGTH 8attr SQL_COLUMN_PRECISION 19attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 19attr SQL_DESC_OCTET_LENGTH 8attr SQL_DESC_PRECISION 19attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 20select real 0attr SQL_COLUMN_LENGTH 4attr SQL_COLUMN_PRECISION 7attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 24attr SQL_DESC_OCTET_LENGTH 4attr SQL_DESC_PRECISION 24attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 14select float 0attr SQL_COLUMN_LENGTH 8attr SQL_COLUMN_PRECISION 15attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 53attr SQL_DESC_OCTET_LENGTH 8attr SQL_DESC_PRECISION 53attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 24select smallmoney 0attr SQL_COLUMN_LENGTH 12attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 4attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 12attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 4attr SQL_DESC_DISPLAY_SIZE 12select money 0attr SQL_COLUMN_LENGTH 21attr SQL_COLUMN_PRECISION 19attr SQL_COLUMN_SCALE 4attr SQL_DESC_LENGTH 19attr SQL_DESC_OCTET_LENGTH 21attr SQL_DESC_PRECISION 19attr SQL_DESC_SCALE 4attr SQL_DESC_DISPLAY_SIZE 21select numeric(10,2) 0attr SQL_COLUMN_LENGTH 12attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 2attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 12attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 2attr SQL_DESC_DISPLAY_SIZE 12select numeric(23,4) 0attr SQL_COLUMN_LENGTH 25attr SQL_COLUMN_PRECISION 23attr SQL_COLUMN_SCALE 4attr SQL_DESC_LENGTH 23attr SQL_DESC_OCTET_LENGTH 25attr SQL_DESC_PRECISION 23attr SQL_DESC_SCALE 4attr SQL_DESC_DISPLAY_SIZE 25select datetime '2006-04-14'attr SQL_COLUMN_LENGTH 16attr SQL_COLUMN_PRECISION 23attr SQL_COLUMN_SCALE 3attr SQL_DESC_LENGTH 23attr SQL_DESC_OCTET_LENGTH 16attr SQL_DESC_PRECISION 3attr SQL_DESC_SCALE 3attr SQL_DESC_DISPLAY_SIZE 23select smalldatetime '2006-04-14'attr SQL_COLUMN_LENGTH 16attr SQL_COLUMN_PRECISION 16attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 16attr SQL_DESC_OCTET_LENGTH 16attr SQL_DESC_PRECISION 0attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 19select char(10) 'hi!'attr SQL_COLUMN_LENGTH 10attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 10attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 10select varchar(11) 'hi!'attr SQL_COLUMN_LENGTH 11attr SQL_COLUMN_PRECISION 11attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 11attr SQL_DESC_OCTET_LENGTH 11attr SQL_DESC_PRECISION 11attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 11select nchar(12) 'hi!'## TODO#attr SQL_COLUMN_LENGTH 24attr SQL_COLUMN_PRECISION 12attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 12## TODO#attr SQL_DESC_OCTET_LENGTH 24attr SQL_DESC_PRECISION 12attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 12select nvarchar(13) 'hi!'## TODO#attr SQL_COLUMN_LENGTH 26attr SQL_COLUMN_PRECISION 13attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 13## TODO#attr SQL_DESC_OCTET_LENGTH 26attr SQL_DESC_PRECISION 13attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 13select text 'hi!'attr SQL_COLUMN_LENGTH 4096attr SQL_COLUMN_PRECISION 4096attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 4096attr SQL_DESC_OCTET_LENGTH 4096attr SQL_DESC_PRECISION 4096attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 4096select ntext 'hi!'## TODO#attr SQL_COLUMN_LENGTH 4096attr SQL_COLUMN_PRECISION 2048attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 2048## TODO#attr SQL_DESC_OCTET_LENGTH 4096attr SQL_DESC_PRECISION 2048attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 2048select binary(10) 'hi!'attr SQL_COLUMN_LENGTH 10attr SQL_COLUMN_PRECISION 10attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 10attr SQL_DESC_OCTET_LENGTH 10attr SQL_DESC_PRECISION 10attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 20select varbinary(11) 'hi!'attr SQL_COLUMN_LENGTH 11attr SQL_COLUMN_PRECISION 11attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 11attr SQL_DESC_OCTET_LENGTH 11attr SQL_DESC_PRECISION 11attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 22select image 'hi!'attr SQL_COLUMN_LENGTH 4096attr SQL_COLUMN_PRECISION 4096attr SQL_COLUMN_SCALE 0attr SQL_DESC_LENGTH 4096attr SQL_DESC_OCTET_LENGTH 4096attr SQL_DESC_PRECISION 4096attr SQL_DESC_SCALE 0attr SQL_DESC_DISPLAY_SIZE 8192# some additional tests using ARDset DESC_CONCISE_TYPE SQL_NUMERICset DESC_PRECISION 20set DESC_SCALE 4set DESC_CONCISE_TYPE SQL_INTEGERattr DESC_TYPE SQL_INTEGERattr DESC_LENGTH 0attr DESC_PRECISION 0attr DESC_SCALE 0
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -