Microsoft SQL Serverbcp (bulk copy program) Utility
The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.
Basic DDL Operations in MS SQL Server
Example to Import Data without a Format File(using Native Format )
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0