Breaking News: Grepper is joining You.com. Read the official announcement!

update select sql

Add Answer

uzii answered on November 12, 2019 Popularity 10/10 Helpfulness 3/10

answer update select sql

related sql update from select

related sql update query

related Update Query in SQL Server

related sql server update from select

related Update Query in SQL Server

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

related update table from select query

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

related sql update query

update select sql

Comment

--the simplest way of doing this 
UPDATE
    table_to_update,
    table_info
SET
    table_to_update.col1 = table_info.col1,
    table_to_update.col2 = table_info.col2

WHERE
    table_to_update.ID = table_info.ID

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: select sql

Link to this answer
Share Copy Link

Contributed on Jun 16 2021

uzii

0 Answers Avg Quality 2/10

Closely Related Answers

sql update from select

Comment

UPDATE YourTable 
SET Col1 = OtherTable.Col1, 
    Col2 = OtherTable.Col2 
FROM (
    SELECT ID, Col1, Col2 
    FROM other_table) AS OtherTable
WHERE 
    OtherTable.ID = YourTable.ID

Popularity 10/10 Helpfulness 7/10 Language sql

Source: stackoverflow.com

Tags: select se

Link to this answer
Share Copy Link

Contributed on Apr 02 2020

Ankur

0 Answers Avg Quality 2/10

sql update query

Comments(1)

314

--update query example
 UPDATE table_name
 SET column1 = value1, column2 = value2, ...
 WHERE condition;

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 12 2019

Black Tailed Deer

0 Answers Avg Quality 2/10

Update Query in SQL Server

Comment

 
  UPDATE table1
  SET column2 = 'Your Text', column3 = 45000
  WHERE column1=5

Popularity 10/10 Helpfulness 5/10 Language sql

Source: naycode.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 13 2021

Ayaz Ullah Sharif

0 Answers Avg Quality 2/10

sql server update from select

Comment

UPDATE your_table_name
SET column1 = select_statement.column1,
    column2 = select_statement.column2
FROM (
    SELECT column1, column2
    FROM another_table
    -- Optional: Add JOIN or WHERE conditions to filter/select specific records
) AS select_statement
WHERE your_table_name.id = select_statement.id;

Popularity 8/10 Helpfulness 3/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Update Query in SQL Server

Comment

  Update salesTransaction
  Set Unit_Price=45.41,Item_Number='Milk-1'
  Where trx_id=1249

Popularity 10/10 Helpfulness 3/10 Language sql

Source: naycode.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 13 2021

Ayaz Ullah Sharif

0 Answers Avg Quality 2/10

How do I UPDATE from a SELECT in SQL Server?

Comment

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'

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.thecodeteacher.com

Tags: select se

Link to this answer
Share Copy Link

Contributed on Dec 23 2021

thecodeteacher

0 Answers Avg Quality 2/10

update table from select query

Comment

UPDATE your_table
SET column1 = new_value1,
    column2 = new_value2,
    ...
FROM (
    SELECT column_to_update, value
    FROM another_table
    WHERE some_condition
) AS subquery
WHERE your_table.join_column = subquery.join_column;

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

How do I UPDATE from a SELECT in SQL Server?

Comment

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;

Popularity 10/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: select se

Link to this answer
Share Copy Link

Contributed on Feb 05 2022

shafeeque

0 Answers Avg Quality 2/10

sql update query

Comments(1)

200000

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql sql-update

Link to this answer
Share Copy Link

Contributed on Apr 03 2021

Brave Bear

0 Answers Avg Quality 2/10

update select sql

Contents

More Related Answers

update select sql

Closely Related Answers

sql update from select

sql update query

Update Query in SQL Server

sql server update from select

Update Query in SQL Server

How do I UPDATE from a SELECT in SQL Server?

update table from select query

How do I UPDATE from a SELECT in SQL Server?

sql update query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.