hi - I want to call a stored procedure from C# and pass it 2 values. ID and Action.
Action will be decrement or increment.
I want to find row in table and decrement a column value or increment the value depending on the action.
I also need to lock the current value so that other users can't change it in between my read and update.
I'd like as much as possible in the stored procedure.