-- 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');