1234567891011121314151617181920212223242526272829 |
- -- https://www.51cto.com/article/235614.html
- -- https://www.cnblogs.com/jinzhenshui/archive/2010/05/26/1744179.html
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'char');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'varchar');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'text');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'nchar');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'nvarchar');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'ntext');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'uniqueidentifier');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'xml');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'LONG', 9, 'bigint');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'decimal');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'money');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'smallmoney');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DECIMAL', 9, 'numeric');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'INTEGER', 9, 'int');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'INTEGER', 9, 'smallint');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'INTEGER', 9, 'tinyint');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DOUBLE', 9, 'float');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'FLOAT', 9, 'real');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'time');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'date');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'datetime9');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'datetimeoffset');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'datetime');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'DATE', 9, 'smalldatetime');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'bit');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'binary');
- INSERT INTO `digital_operation`.`etl_sql_column` ( `sql_column_type`, `ds_type`, `column_type`) VALUES( 'STRING', 9, 'varbinary');
|