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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-27 : 07:44:35
|
| Niran writes "I want to update the records from one table to the other one which has the same fields and the structure.Is it possible through single query.Iam using visual basic 6.0 for this and it take lot of time to loop through all the records(around 10000).Is there any thing like bulk update by using where condition.Please let me out of his problem.Thanks in advance.Niranjan C" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-01-27 : 08:04:58
|
| Do you mean update or insert? You can easily insert data into another table with a similar structure by using the INSERT INTO...SELECT construct. For example:INSERT INTO MyOrders (OrderID, OrderDate, CustomerID, Amount)SELECT OrderID, OrderDate, CustID, TotalPrice FROM Orders WHERE OrderID < 1000OS |
 |
|
|
|
|
|
Reg. Bulk Update