Sql update multiple tables

Update table sql multiple set

-- CANT do multiple sets but can do case
UPDATE table
SET ID = CASE WHEN ID = 2555 THEN 111111259 
              WHEN ID = 2724 THEN 111111261
              WHEN ID = 2021 THEN 111111263
              WHEN ID = 2017 THEN 111111264
         END
WHERE ID IN (2555,2724,2021,2017)

Source: stackoverflow.com

Sql update multiple tables

/*You can't update multiple tables in one statement,
however, you can use a transaction to make sure that
two UPDATE statements are treated atomically.
You can also batch them to avoid a round trip.*/


BEGIN TRANSACTION;

UPDATE Table1
  SET Table1.LastName = 'DR. XXXXXX' 
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '011008';

UPDATE Table2
SET Table2.WAprrs = 'start,stop'
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '011008';

COMMIT;

Source: stackoverflow.com

Similar codes

0 vote363 views1 answer
Openquery join two tables
SQL
24 votes384 views6 answers
Alter table name sql
SQL
18 votes366 views3 answers
Get the list of all tables in sql server
SQL
1 vote360 views1 answer
What is int in mysql
SQL
9 votes355 views1 answer
Mysql check date range
SQL
0 vote363 views1 answer
Display all node label neo4j
SQL
9 votes381 views4 answers
Postgresql export database
SQL
0 vote355 views1 answer
Leftjoin in sql
SQL
0 vote358 views1 answer
Enable sql server full text indexing
SQL
3 votes356 views1 answer
Uppercase and lowercase in sql
SQL