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

Jul 07, 2019 SQL - How do I UPDATE from a SELECT in SQL Server?

INNER JOIN, MERGE, SQL, SQL Server, UPDATE July 07, 2019

In SQL Server it's possible to INSERT into a table, but can you do the same for UPDATE? The is a common question when learning SQL and learning how to UPDATE from a SELECT in SQL Server.

In SQL Server 2008 (or better), use MERGE

MERGE INTO Table_A A
   USING (
          SELECT id, col1, col2 
            FROM Table_B 
           WHERE tsql = 'cool'
         ) B
      ON A.id = B.id
WHEN MATCHED THEN
   UPDATE 
      SET col1 = B.col1, 
          col2 = B.col2;

Otherwise you can use and INNER JOIN

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'

admin API array async Birthday BookGuide Button bytes c# c# enum to int c# int to enum c# int to string c# iterate dictionary c# loop through dictionary c# outofmemoryexception c# run as admin C++ cast cheatsheet CLASSPATH compare convert int to string Dad Dictionary editor enum exception exit Fathers Day for for loop foreach generic Gift gift guide Git global Guide HTML INNER JOIN int iterate Java java.lang.OutOfMemoryError Javascript jQuery JSON KnockoutJS list loop MERGE nested loop outofmemory PHP PHP Redirect PowerShell programmer gift programmer mugs programmer shirts programmer stickers python python bytes to string python external command python for loop python int to string quit random Redirect repr() shell command SQL SQL Server STDIN STDOUT str() string switch system.outofmemoryexception c# systemoutofmemory type UPDATE variables vi vim _

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

Back to The Programmer Blog

shop

2024

2023

2020

2019

2018

2017