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 |
|
jsn
Starting Member
1 Post |
 Posted - 2009-01-06 : 05:12:22
|
| Plz tel me the query how to update more than 1 table at a time using single sql query |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-01-06 : 05:18:10
|
| No you cant update more than one table in a single query. You have to use separate update stmts for each table |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-06 : 05:20:29
|
quote:
Originally posted by raky
No you cant update more than one table in a single query. You have to use separate update stmts for each table
Unless you are updating the table through a view. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 08:28:22
|
| http://weblogs.sqlteam.com/brettk/archive/2008/04/03/60560.aspx |
|
|
|
Zul
Starting Member
17 Posts |
Posted - 2009-05-29 : 02:31:14
|
| how can update table through a view, but in my problem is the table is diferent db with the view?? |
|
|
|
Zul
Starting Member
17 Posts |
Posted - 2009-05-29 : 02:50:22
|
| how can update table through a view, but in my problem is the table is diferent db with the view?? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-29 : 03:00:00
|
what sakets is referring to "update table through a view" is creating update trigger on the view and perform the update to the required tables in the update trigger.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SQL Update