Use Unicode native format for bulk transfer of data between instances of SQL Server, which eliminates conversion of data types to and from character format. Using bcp and Unicode Native Format to ...

In contrast, a regular INSERT statement retains the null value instead of inserting a default value. The INSERT ... SELECT * FROM OPENROWSET(BULK...) statement provides the same basic behavior as ...