SQL Server 2000
There are six options for copying data using bcp or BULK INSERT.
|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.|