/SQL/How to update the multiple rows in sql

How to update the multiple rows in sql

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

How to update the multiple rows in sql

update with in condition

Similar codes

0 vote287 views1 answer
Running query in redshift
SQL
0 vote308 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
19 votes285 views2 answers
Mysql add column after another
SQL
45 votes354 views5 answers
Grant all privileges mysql
SQL
2 votes309 views1 answer
Mysql create user with remote access
SQL
1 vote323 views1 answer
Oracle create program if not exists
SQL
1 vote300 views1 answer
Oracle previous year
SQL
0 vote276 views1 answer
How to find database collation in postgres
SQL
0 vote298 views1 answer
Enable sql server full text indexing
SQL
0 vote277 views1 answer
TSQL function split string
SQL