Expand|Select|Wrap|Line Numbers
- INSERT INTO tblOrders (custname, custdetails, orderdate) VALUES (@custname, @custdetails, @orderdate)
I'm trying to get the Identity value from the first INSERT statement to use in the second INSERT statement:
Expand|Select|Wrap|Line Numbers
- INSERT INTO tblOrderDetails (orderid, productid, productcost) VALUES (@orderid, @productid, @productcost)