Quickest method to load large data into a table is to use "BCP"

How do you load large data to the SQL server database?

Question Posted / uma lakshman

Answer Posted / uma lakshman

Quickest method to load large data into a table is to
use "BCP"(bulk copy).

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different methods available under sqlcommand class to access the data?

1057

State the difference between union and union all?

889

Is it possible for a stored procedure to call itself or recursive stored procedure?

891

What is "scheduled jobs" or "scheduled tasks"?

911

define and explain the differences between clustered and non-clustered indexes.

1118

What are the authentication modes in sql server? How can it be changed?

1051

How to list all triggers in the database with sys.triggers in ms sql server?

1011

What is partition, how will you implement it? : sql server analysis services, ssas

991

What is the default server name for sql server?

1087

What are the tool windows in sql server management studio? : sql server management studio

1014

How real and float literal values are rounded?

1094

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1058

What are the different types of sub-queries?

994

What are the different sql server versions?

930

What is bulkcopy in sql?

895