How to UPDATE from a SELECT in SQL Server?



  • In SQL Server, it’s possible to insert into a table using a SELECT statement:

    INSERT INTO Table (col1, col2, col3)
    SELECT col1, 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

    Sarika//mindmajix.com/ssis-training


Log in to reply