There are lots of options available in BCP command, you can see by typing “bcp /”? in the command prompt.
C:\>bcp northwind.dbo.customers out c:\custdb.txt -T -c
While executing BCP command if it gives error saying “’bcp’ is not recognized as an internal or external command,operable program or batch file. Then go to “C:\Program Files\Microsoft SQL Server\90\Tools\binn” using command prompt and rerun the same command.
Let’s go through with an example, here we are using command prompt to run the bcp command. It will export the selected records from employee table into data file separated by comma, after executing it will generate output file in c:\output.txt.
C:\Program Files\Microsoft SQL Server\90\Tools\binn>bcp northwind.dbo.customers out c:\custdb.txt -T -c
21 rows copied.
To know more baout BULK copy use this link SQL Server – Export data using BULK copy command with Example