Click here to Skip to main content
15,891,184 members
Articles / Programming Languages / SQL

SQL Bulk copy method to insert large amount of data to the sql database

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
11 Jan 2012CPOL 11.3K   1  
Thank you for this article, okay it's technical.But we can use other methods considered as more efficient. *For Microsoft SQL Server, we can use bulk copy program(bcp). The tool is embeddedwithin SQL server so you can invoke it inside your application - whatever language you use....

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
3 Jan 2012bluesathish 1 alternative  
Fastest and most efficient method to insert large amount of records to a SQL Server database from our system generated datatable.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions