O'Reilly logo
  • 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);


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


Insert a row(s) into an existing target table.