Sql update from select

UPDATE YourTable 
SET Col1 = OtherTable.Col1, 
    Col2 = OtherTable.Col2 
FROM (
    SELECT ID, Col1, Col2 
    FROM other_table) AS OtherTable
WHERE 
    OtherTable.ID = YourTable.ID

Source: stackoverflow.com

Sql update from select

UPDATE t1
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
FROM MY_TABLE AS t1
JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
WHERE t1.COL3 = 'OK';

How do I UPDATE from a SELECT in SQL Server?

UPDATE     Table_A SET     Table_A.col1 = Table_B.col1,     Table_A.col2 = Table_B.col2 FROM     Some_Table AS Table_A     INNER JOIN Other_Table AS Table_B         ON Table_A.id = Table_B.id WHERE     Table_A.col3 = 'cool'

Source: thecodeteacher.com

How do I UPDATE from a SELECT in SQL Server?

In SQL Server 2008 (or newer), use MERGE

MERGE INTO YourTable T
   USING other_table S 
      ON T.id = S.id
         AND S.tsql = 'cool'
WHEN MATCHED THEN
   UPDATE 
      SET col1 = S.col1, 
          col2 = S.col2;
Alternatively:

MERGE INTO YourTable T
   USING (
          SELECT id, col1, col2 
            FROM other_table 
           WHERE tsql = 'cool'
         ) S
      ON T.id = S.id
WHEN MATCHED THEN
   UPDATE 
      SET col1 = S.col1, 
          col2 = S.col2;

Source: stackoverflow.com

Similar codes

1 vote114 views1 answer
Select 2 rows in sql
SQL
10 votes146 views4 answers
Sql server pagination
SQL
0 vote112 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
3 votes125 views2 answers
How to modify rows in SQL Server
SQL
0 vote108 views1 answer
Uncomment listen_address=localhost
SQL
8 votes112 views1 answer
Sql remove leading spaces
SQL
0 vote117 views1 answer
Drop column from local database postgres pgadmin
SQL
2 votes101 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
6 votes91 views1 answer
Oracle rank() over (partition)
SQL
0 vote104 views1 answer
Group_concat only returns one row
SQL