Data Mining Interview Questions and Answers

 

What is bulk insert?

The Bulk Insert task provides an efficient way to copy large amounts of data into
a SQL Server table or view. For example, suppose your company stores its million-row
product list on a mainframe system, but the company's e-commerce system uses SQL
Server to populate Web pages. You must update the SQL Server product table nightly
with the master product list from the mainframe. To update the table, you save the
product list in a tab-delimited format and use the Bulk Insert task to copy the
data directly into the SQL Server table.

Posted by:Richards