SQL Bulk Insert – how retain empty string values
I am using the T-SQL Bulk Insert command to insert large text files into tables. The tables have many nvarchar columns, I found that if the text file has empty string values for any nvarchar column, bulk insert will insert NULL in that table column.
SQL Bulk Insert – how retain empty string values
I am using the T-SQL Bulk Insert command to insert large text files into tables. The tables have many nvarchar columns, I found that if the text file has empty string values for any nvarchar column, bulk insert will insert NULL in that table column.
SQL Bulk Insert – how retain empty string values
I am using the T-SQL Bulk Insert command to insert large text files into tables. The tables have many nvarchar columns, I found that if the text file has empty string values for any nvarchar column, bulk insert will insert NULL in that table column.