How can we import and export using BCP utility in SQL?

In the first question you can see there is huge list of different command. We will try to
cover only the basic commands which are used.
-T: - signifies that we are using windows authentification
-t: - By default every record is tab separated. But if you want to specify comma separated
you can use this command.
-r :- This specifies how every row is separated. For instance specifying –r/n specifies that
every record will be separated by ENTER.
bcp adventureworks.sales.salesperson out c:\salesperson.txt -T
bcp adventureworks.sales.salespersondummy in c:\salesperson.txt –T
When you execute the BCP syntax you will be prompted to enter the following values
(data type, length of the field and the separator) as shown in figure below. You can either
fill it or just press enter to escape it. BCP will take in the default values.