Tsql merge example

MERGE esqlProductTarget T
USING esqlProductSource S
ON (S.ProductID = T.ProductID)
WHEN MATCHED 
     THEN UPDATE
     SET    T.Name = S.Name,
            T.ProductNumber = S.ProductNumber,
            T.Color = S.Color
WHEN NOT MATCHED BY TARGET
THEN INSERT (ProductID, Name, ProductNumber, Color)
     VALUES (S.ProductID, S.Name, S.ProductNumber, S.Color)
WHEN NOT MATCHED BY SOURCE
THEN DELETE;

Source: essentialsql.com

Merge clause with inner join

MERGE table1
USING (SELECT table3.keycolumn,
              table2.DataColumn1,
              table2.DataColumn2
       FROM table2
       INNER JOIN table3
           ON table2.anotherKey = table3.anotherKey
       WHERE table2.anotherKey = 'A1') tmpTable
ON 
   table1.keyColumn = tmpTable.keyColumn
WHEN MATCHED THEN
       UPDATE
       SET table1.DataColumn1 = tmpTable.DataColumn1
            ,table1.DataColumn2 = tmpTable.DataColumn2;

Source: stackoverflow.com

Similar codes

0 vote216 views1 answer
Install sql server windows 10
SQL
-1 vote236 views1 answer
Sql show custom constraints
SQL
7 votes204 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote215 views2 answers
Postgres another version
SQL
0 vote224 views1 answer
Create a plsql object
SQL
1 vote217 views1 answer
Sqlite show columns in table
SQL
25 votes230 views6 answers
How to change column name in mysql
SQL
18 votes219 views4 answers
Mysql current date between two dates
SQL
1 vote266 views1 answer
OSError: mysql_config not found
SQL
4 votes196 views2 answers
How to count items with same name in sql
SQL