Notice: The Monaca & Onsen UI Community Forum is shutting down.

For Onsen UI bug reports, feature requests and questions, please use the Onsen UI GitHub issues page. For help with Monaca, please contact Monaca Support Team.

Thank you to all our community for your contributions to the forum. We look forward to hearing from you in the new communication channels.

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