bulk update in sql server 2005
hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance...
View Answer
| Apr 25 2008 4:47 AM GMT
| asked by
MinteeLoki
BULK UPDATE, SQL Server 2005
bulk update in SQL Server 2005
I need to updata Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows, how to write a procedure to accomplish this in sql server 2005?
View Answer
| Apr 23 2008 9:49 PM GMT
| asked by
Rl
BULK UPDATE, SQL Server 2005


