Yes, SQL Server **2012** supports multiple inserts - that feature was introduced in SQL Server **2008**.

That makes me wonder if you have Management Studio 2012, but you're really connected to a SQL Server **2005** instance ...

What version of the SQL Server **engine** do you get from `SELECT @@VERSION` ??

These StackOverflow questions [here][Q1], [here][Q2], and [here][Q3] all say the same thing, but I can't get it to run in SSMS or SQLFiddle



    CREATE TABLE #Names
      ( 
        Name1 VARCHAR(100),
        Name2 VARCHAR(100)
      ) 

    INSERT INTO #Names
      (Name1, Name2)
    VALUES
      ('Matt', 'Matthew'),
      ('Matt', 'Marshal'),
      ('Matt', 'Mattison')

When I execute this is SSMS, the insert fails with the following message on the first line after `VALUES`

> Msg 102, Level 15, State 1, Line 10    
> Incorrect syntax near ','.

This [**Fiddle**][fiddle] runs without the `#` sign, and the schema executes successfully when the table name is `#Names`, but I get the following message when I try to select * from the table 

> Invalid object name '#NAMES'.: SELECT * FROM #NAMES

Does SQL Server 2012 support multiple inserts?

----

**Update**: Apparently accessing a 2005 server on SSMS 2012....



    SELECT @@VERSION --Returns: Microsoft SQL Server 2005

    



 [Q1]: https://stackoverflow.com/questions/452859/inserting-multiple-rows-in-a-single-sql-query
 [Q2]: https://stackoverflow.com/questions/2676493/insert-multiple-rows-into-temp-table-with-one-command-in-sql2005
 [Q3]: https://stackoverflow.com/questions/2624713/how-do-i-insert-multiple-rows-without-repeating-the-insert-into-dbo-blah-part
 [fiddle]: http://sqlfiddle.com/#!18/32d8f/1