/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

1 vote141 views1 answer
Set statiscis on in ssms
SQL
4 votes89 views1 answer
And or sql order of operations
SQL
0 vote139 views1 answer
Mysql query problems and solutions
SQL
0 vote239 views1 answer
How to use select union and loop
SQL
7 votes163 views1 answer
Show line number in sql server
SQL
0 vote131 views1 answer
Exec procedure oracle
SQL
4 votes150 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote171 views1 answer
Psql create usr
SQL
0 vote141 views1 answer
Mysql backup query
SQL
1 vote145 views1 answer
Key validation sql
SQL