Increase column by 1

Can someone help me out with a fairly simple Stored Procedure?

I need a sp that simply decreases the Quantity column by 1 for a given record.

Thanks.
LVL 3
natejacobsAsked:
Who is Participating?
 
rafranciscoCommented:
CREATE PROCEDURE DecreaseQuantity  @RecordID INT
AS
UPDATE YourTable
SET Quantity = Quantity - 1
WHERE YourID = @RecordID
0
 
natejacobsAuthor Commented:
Thanks rafrancisco.  I'm SQL challenged!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.