Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunspot
Starting Member
8 Posts |
 Posted - 2004-02-19 : 03:02:00
|
| Hi,I would like to ask wat is the most efficient method of transferring data from one table to another table?I am using Visual C# 2003 & sqlserver 2000.Currently, I am using a select statement to select the columns needed and transferring. I got a table B of 6,000,000 of datarows and 16 columns and I need to transfer data from this table B into another table A according to some constraints.---------------------------------------------------------------------INSERT INTO sunspot.tableA SELECT * FROM sunspot.TableB WHERE L_LineNumber = " + Temp1.ToString()----------------------------------------------------------------------It is ok if I execute this for smaller number of rows (20000), but it will display error if I execute for larger number of rows(50000). |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-02-19 : 03:18:38
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=32655You only need to ask in one forum ;)-------Moo. :) |
 |
|
|
|
|
|
more efficient way to transfer data?