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 hotfixes and patches in sql server?

1011

Can sql servers link to other servers like oracle?

835

What is the filtered index?

1046

explain declarative management framework (dmf) in sql server 2008?

982

what is a join? : Sql server database administration

1232

How to find index size for each index on table?

997

What is a constant or literal in ms sql server?

1040

what are database files and filegroups? : Sql server database administration

939

What is the main purpose of having conversation group?

894

What is the difference between createstatement and preparedstatement?

930

What do you mean by data integrity?

1060

what are the different ways to return the rowcount of a table?

991

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1142

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1022

How to loop through result set objects using mssql_fetch_array()?

1067