/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 vote182 views1 answer
Sql date between one week
SQL
0 vote196 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote212 views1 answer
Drop specific row postgresql
SQL
1 vote207 views1 answer
Isnull sql server
SQL
0 vote198 views1 answer
Disableforiegn key check
SQL
0 vote205 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote218 views1 answer
T-SQL Never ending DELETE
SQL
0 vote177 views1 answer
Import sql mysql ubuntu
SQL
0 vote260 views1 answer
Create table with timestamp mysql youtube
SQL
3 votes189 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL