Bcp Utility

From SQL Server Wiki
Revision as of 10:55, 23 June 2017 by Rsterbal (talk | contribs) (Created page with "*Download page: [https://msdn.microsoft.com/en-us/library/ms162802.aspx bcp Utility] *Release date: 2012-02-11 *Support Version: 2008/2012/2014/2016 *Author: Microsoft *Free v...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  • Download page: bcp Utility
  • Release date: 2012-02-11
  • Support Version: 2008/2012/2014/2016
  • Author: Microsoft
  • Free version: Yes
  • Price: No

The bcp utility bulk copies data between an instance of MicrosoftSQL 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. Except when used with the queryout option, the utility requires no knowledge of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.