Listing 4: Test Driver for usp_insertOrder
DECLARE @return_status int
DECLARE @order_number int
EXEC @return_status = usp_insertOrder 4, 2, @order_number OUTPUT
SELECT @order_number "Order Number", @return_status "Return Status"