i have a text file (pipeline separator) with null value in some column. when i imported it to sql server with bcp utility, import was successful. however, i check the table with select query in SQL Server Management Studio and the result for null value invalid. invalid is column must be null value, it fill blank value. colomn must be blank value, it fill with null value. i was frusted. all the way i try, it never solved.
command prompt for bcp like this
thank you all
question from:https://stackoverflow.com/questions/66064060/bcp-import-result-with-null-value-invalid