![]() ![]() WHEN DATA_TYPE IN ('CHAR','VARCHAR') THEN '', Column_name) (NOT USED)ĭECLARE varchar(8000) = varchar(8000) = varchar(4000) = WHEN LIKE THEN ' ELSE ' ' END'ĭECLARE varchar(8000) = varchar(4000) = varchar(8000) = select * FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'csv_table' Standard convert always use double qoutes. Date format 121 for 'DATETIME','DATETIME2','DATE', this results in YYYY-MM-DD hh:mi:ss.mmm YYYY-MM-DD hh:mi:ss.mmmmmmm YYYY-MM-DD hh:mi:ss.sssssss Quoted when a special character is used. SELECT = COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = > 26 SET = '- Dummy Header' - Maybe the number of columns as A,B,C,D. IF >=128 BEGIN - If the header goes beyond 128 characters, it is not accepted as a 'column_nam' DataLines - Supplied by executed SELECT CommentLine - Supplied by executed SELECT Header as column_name - Supplied by executed SELECT ![]() Select = FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = - First Line select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'csv_table' Then use an empty header or a dummy header Be carefull maximum header length as a single column_name is 128 characters. + char(13)+char(10) to get more readable script. ĭECLARE varchar(30) = VARCHAR(30) = '+' + char(13)+char(10) - Use a comma ',' for distinct fields for inspection. Header and Data type lines include (optional). (Extra headers can be removed other adaptations are possible). ![]()
0 Comments
Leave a Reply. |