Organizational Research By

Surprising Reserch Topic

UPDATE from SELECT using SQL Server


n SQL Server, it's possible to insert into a table using a SELECT statement:

INSERT INTO Table (col, col2, col3)
    SELECT col, col2, col3 FROM other_table WHERE sql = 'cool'

Is it also possible to update via a SELECT? I have a temporary table containing the values, and would like to update another table using those values. Perhaps something like this:

UPDATE Table SET col1, col2
    SELECT col1, col2 FROM other_table WHERE sql = 'cool'
    WHERE Table.id = other_table.id

 

asked May 22, 2015 in MYSQL by rahulgii
0 votes
42 views



Related Hot Questions



Government Jobs Opening


...