Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

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


1 - 2 of 2
<<PREVIOUS 1 NEXT>>