LISTING 2: Making a New Order with Three Order Parts

DECLARE @neworderid AS int

INSERT INTO Orders(customerid, orderdate)
  VALUES(1001, GETDATE())

SELECT @neworderid = @@identity

INSERT INTO OrderDetails(orderid, partid, qty)
  VALUES(@neworderid, 101, 10)
INSERT INTO OrderDetails(orderid, partid, qty)
  VALUES(@neworderid, 102, 10)
INSERT INTO OrderDetails(orderid, partid, qty)
  VALUES(@neworderid, 103, 10)