-
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);
Minimise