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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-09-07 : 02:46:12
|
| dear userits posible to update query to upldate a multiple colomn of multiple table in one update statement.thanks in advance |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-07 : 02:51:34
|
| there is any common column between the table then u can update in a single update statement... |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-07 : 03:54:59
|
You cannot update more than one table at a time.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-09-07 : 04:04:43
|
any particular reason you need to do this ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-09-07 : 07:17:05
|
| thanks to all to replaymy req. is following my sample table.tab1empid name addres 1 a add-a 2 b add-b 3 c add-ctab2salid empid salary 1 1 1000 2 2 2000 3 3 3000tab3deptid empid depnm1 1 comp2 2 mkt3 3 fin their is one common colom is emp idi will update two colom of salary in tab2 and depnm in tabl3 for emp in one update query .so how i can write this query.thanks |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-07 : 07:20:25
|
quote:
Originally posted by webfred
You cannot update more than one table at a time / in one statement.
No, you're never too old to Yak'n'Roll if you're too young to die.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
update multiple col to multiple table