-- Syntax for SQL Server and Azure SQL Database  

​

[ WITH <common_table_expression> [ ,...n ] ]  

INSERT   

{  

        [ TOP ( expression ) [ PERCENT ] ]   

        [ INTO ]   

        { <object> | rowset_function_limited   

          [ WITH ( <Table_Hint_Limited> [ ...n ] ) ]  

        }  

    {  

        [ ( column_list ) ]   

        [ <OUTPUT Clause> ]  

        { VALUES ( { DEFAULT | NULL | expression } [ ,...n ] ) [ ,...n     ]   

        | derived_table   

        | execute_statement  

        | <dml_table_source>  

        | DEFAULT VALUES   

        }  

    }  

}  

[;]  

<object> ::=  

{   

    [ server_name . database_name . schema_name .   

      | database_name .[ schema_name ] .   

      | schema_name .   

    ]  

  table_or_view_name  

}  

<dml_table_source> ::=  

    SELECT <select_list>  

    FROM ( <dml_statement_with_output_clause> )   

      [AS] table_alias [ ( column_alias [ ,...n ] ) ]  

    [ WHERE <search_condition> ]  

        [ OPTION ( <query_hint> [ ,...n ] ) ]  

​

-- External tool only syntax  

​

INSERT   

{  

    [BULK]  

    { database_name.schema_name.table_or_view_name | schema_name.table_or_view_name | table_or_view_name }  

    ( <column_definition> )  

    [ WITH (  

        [ [ , ] CHECK_CONSTRAINTS ]  

        [ [ , ] FIRE_TRIGGERS ]  

        [ [ , ] KEEP_NULLS ]  

        [ [ , ] KILOBYTES_PER_BATCH = kilobytes_per_batch ]  

        [ [ , ] ROWS_PER_BATCH = rows_per_batch ]  

        [ [ , ] ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ]  

        [ [ , ] TABLOCK ]  

    ) ]  

}  

[; ] <column_definition> ::=  

 column_name <data_type>  

    [ COLLATE collation_name ]  

    [ NULL | NOT NULL ]  

<data type> ::=   

[ type_schema_name . ] type_name   

    [ ( precision [ , scale ] | max ]  

-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  

​

INSERT INTO { database_name.schema_name.table_name | schema_name.table_name | table_name }

    [ ( column_name [ ,...n ] ) ]  

    {   

      VALUES ( { NULL | expression } )  

      | SELECT <select_criteria>  

    }  

    [ OPTION ( <query_option> [ ,...n ] ) ]  

[;]