Write TWO stored procedures, one for adding and another for deleting a purchase order detail.

The user should be able to add/delete a purchase order detail for a particular order. The appropriate columns would be provided as input parameters. The purchase order detail ID will be returned as an output parameter. (for every order in the purchase order table enter at least TWO order details using the test snippet for this procedure). For this requirement you will have to write TWO stored procedures, one for adding and another for deleting a purchase order detail.

× How can I help you?