GitHub

use-unicode-native-format-to-import-or-export-data-sql-server.md

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 ...
GitHub

use-unicode-character-format-to-import-or-export-data-sql-server.md

The Unicode character data format allows data to be exported from a SQL Server instance by using a code page that differs from the code page used by the client. [!INCLUDESQL Server Azure SQL Database ...
Ars Technica

Bulk Insert into Sql server?

Hello all. <BR>I have a collection of comma delimited text files sitting on a network drive. This data needs to be imported daily into our production tables. The destination tables vary depending upon ...
Ars Technica

Using non-printable char in MSSQL bulk import format file as delimiter

I've received a new file to import in our database and the *censored* DBA are the other end got creative with the format. he decided to use 0x01 as field delimiters and 0x02,0x0a,0x10 as record ...