The problem of bcp unix format text in ms SQL Server

I have read a lot of questions on the Internet about the BCP UNIX format file in window. The answer is basically to convert it to the DOS format using tools such as ue, because when the-r \ n parameter is added, BCP will automatically change to \ r \ n

In fact, another trick is to use the parameter-R "0x0a". In this case, you can use BCP without conversion. The world is better...

 

Similar to using bulk insert, use rowterminator = '0x0a '.

 

The above code is used in SQL 2008. If you have different versions of SQL, please let me know!