[ACCEPTED]-SQL Server Insert Without INTO-insert

Accepted answer

Score: 24

The INTO is optional. It is required in ANSI sql but 2 the MS/Sybase developers decided to make 1 it optional.

Score: 6

Check the BNF grammar http://savage.net.au/SQL/

92, 99, SQL:2003

<insert statement> ::= INSERT INTO <insertion target> <insert columns and source>

According 5 to the ANSI spec, INTO should only be optional 4 in a MERGE clause.

For SQL Server (this link from 2000 to 3 show how old it is - it exists from the 2 first version of SQL Server), it is optional. It 1 is also optional for MySQL.

INSERT [ INTO]
    { table_name WITH ( < table_hint_limited > [ ...n ] )
        | view_name
        | rowset_function_limited
    }

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

Score: 4

From MSDN: