top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to update multiple tables in sql server 2008 ?

+1 vote
126 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

...