/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 vote306 views1 answer
Mysql with
SQL
0 vote323 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote394 views1 answer
Generate a random otp in sql server
SQL
0 vote306 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote358 views1 answer
How to select all fieldsin a soql query
SQL
3 votes340 views3 answers
Order by postgres
SQL
0 vote416 views1 answer
Current month transactions in mysql
SQL
0 vote320 views2 answers
T SQl Checking Your Username
SQL
1 vote340 views1 answer
Oracle sql average
SQL
3 votes349 views2 answers
Search text in all sql server stored procedure
SQL