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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Update 2 tables in single statement

Author  Topic 

pravin14u
Posting Yak Master

246 Posts

Posted - 2008-03-13 : 08:04:14
Is it possible to update 2 tables in a single t-sql statement?

If Yes, whats the syntax?


Update Table1,Table2 ... is not working

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-13 : 08:06:53
No.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-03-13 : 08:23:22
Only if you have update trigger that updates other table

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -