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
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.

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.
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
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.