INSERT INTO SELECT | SQL Tutorial and Query Example

Text copied!

INSERT INTO SELECT


  • INSERT INTO SELECT syntax in SQL server
    INSERT INTO target_table (column1, column2, column3, ...)
    SELECT column1, column2, column3, ...
    FROM source_table
    WHERE condition;