/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

0 vote138 views1 answer
Groupby error in mysql
SQL
5 votes134 views1 answer
Sql select ciunt
SQL
1 vote147 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote144 views2 answers
Mysql get routine parameter list
SQL
0 vote150 views1 answer
Mysql random number between 1 and 100
SQL
0 vote141 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote136 views1 answer
Change data type in mysql
SQL
0 vote147 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote144 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote147 views1 answer
Replace content value from old to new sql
SQL