Dustin Waybright thinks this is interesting:

With the INSERT VALUES statement, you can insert one or more rows into a target table based on value expressions. Here’s an example for a statement inserting one row into the Sales.MyOrderValues table.

INSERT INTO Sales.MyOrders(custid, empid, orderdate, shipcountry, freight)
  VALUES(2, 19, '20120620', N'USA', 30.00);