top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to update multiple tables in sql server 2008 ?

+1 vote
97 views
How to update multiple tables in sql server 2008 ?
posted Jun 30, 2015 by Shivaranjini

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

You can not update multiple table in one single update statement.. what you can do is wrap the update statement in a transaction, commit changes only when both update are successful.
Here MSDN Visual Studio gives you a bypass on that.

https://msdn.microsoft.com/en-us/library/f5scy1hs(v=VS.80).aspx

answer Jul 1, 2015 by Amit Kumar Pandey
Similar Questions
+2 votes

I want to update data from one table to another table with year condition.
(OR)
To Update one table based on another table using INNER JOIN

+4 votes

how to check if table exist and if it doesnt exist create table in sql server 2008

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...