Bulk copy with an example

Brief about Bulk copy with an example.

- Bulk copy utility of SQL allows data to be copied from one data file to another.

- The data is first exported from the source data file and then imported into the SQL server using the bcp command.

- It can also be used to transfer data from a table to a file.

- It can be used to write data only to SQL server tables.

- The SqlBulkCopy contains an instance method WriteToServer which is used to transfer the data from the source to the destination.

Syntax:
public void WriteToServer
(
DataTable table
)
How bcp command prompt utility is used to import and export data
The bcp utility is accessed from the command prompt......
Describe how bulk insert statement is used to import data
Bulk Insert is used to copy data from a file into a table or view in a format as specified by the user........
Define distributed queries
Distributed queries access data from multiple heterogeneous sources. These data sources may or may not be stored on the same computer........
Post your comment