Native Format bcp

The following example shows how to copy the publishers table to the PUBL_OUT file using native data format:

bcp pubs..publishers out publ_out /n /Sservername /Usa 
/Ppassword

In the output file the bcp utility adds to the beginning of each field an ASCII character equivalent to the length of the data in a char or varchar field. In a table with numeric data, the information is written to the file in the operating-system data format.