Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The bcp command, BULK INSERT statement, or INSERT ... SELECT * FROM OPENROWSET(BULK...) statement support several basic scenarios. The following table summarizes the scenarios that are supported by each of these methods:
Note
Bulk importing into a partitioned view is unsupported by bcp, BULK INSERT, or INSERT ... SELECT * FROM OPENROWSET(BULK...). Attempts to bulk import data into a partitioned view fail.
The following topics discuss the major scenarios.
| Topic | Description |
|---|---|
Contains descriptions of the different data formats that you can use when copying data between instances of Microsoft SQL Server. |
|
Contains instructions on how to transfer data between different collations, including the use of either column-level collations or code pages that apply to all the columns. |
|
Contains information on how to export a result set from a Transact-SQL statement to a data file. |
|
Contains information on how to export or import data to or from a temporary table. |
|
Contains information on how to export or import data to or from a view. |
See Also
Concepts
Basic Guidelines for Bulk Importing Data
Controlling Trigger Execution When Bulk Importing Data
Other Resources
Format Files for Importing or Exporting Data