Bulk Copy in SQL Server

Bulk copy is one of the simplest and fastest way of transfering data IN and OUT of SQL Server.

We can run BCP from command Prompt as follows.

Step 1: Open Command Prompt and type following command.

Step 2: Enter to start Bulk Copy Operation.