BCP Utility in SQL Server

This topic provides an overview for using the bcp utility to export data from anywhere in a SQL Server database where a SELECT statement works, including partitioned views.
The bcp utility (Bcp.exe) is a command-line tool that uses the Bulk Copy Program (BCP) API. The bcp utility performs the following tasks:
  • Bulk exports data from a SQL Server table into a data file.
  • Bulk exports data from a query.
  • Bulk imports data from a data file into a SQL Server table.
  • Generates format files.

No comments:

Post a Comment

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...