Export (0) Print
Expand All

Copying Data

SQL Server 2000

There are six options for copying data using bcp or BULK INSERT.

Topic Description
Copying Data Between Servers Describes which data format to use when copying data between instances of Microsoft® SQL Server™.
Copying Data from a Data File to SQL Server Describes how to copy data from a data file to an instance of SQL Server, including how to handle identity values and image data.
Copying Data From a Query to a Data File Describes how to copy the result set from a Transact SQL statement to a data file.
Copying Data To or From a Temporary Table Describes how to copy data to or from a temporary table.
Copying Data To or From a View Describes how to copy data to or from a view.
Copying Data Between Different Collations Describes how to copy data between different collations, including the use of column-level collations.

Show:
© 2014 Microsoft