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);
- 10. Inserting, Updating, and Deleting Data
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Insert a row(s) into an existing target table.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/78498/