Use the BCP command in sqlserver

We all know the usage of BCP. However, if you encounter columns with special strings, such as columns with line breaks, you cannot use the general usage. You need to specify the column Terminator and row Terminator.

BCP dbname. DBO. tablename out d: \ tablename.txt - C - T - T0x01 - R0x02
BCP dbname. DBO. tablename In D: \ tablename.txt - C - T - T0x01 - R0x02