/SQL/How do I UPDATE from a SELECT in SQL Server?

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 vote166 views1 answer
Search all database tables for a value sqlserver
SQL
3 votes219 views2 answers
Funktion LOWER/UPPER sql
SQL
19 votes221 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote132 views1 answer
Procedures and functions in pl/sql
SQL
10 votes123 views1 answer
Oracle view dependencies
SQL
0 vote168 views1 answer
Select from another database
SQL
2 votes183 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
1 vote172 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote170 views1 answer
Oracle archivelog usage
SQL
0 vote176 views1 answer
If null don't update
SQL