尝试UPDATE语句:

Try an UPDATE statement:

UPDATE RawMat SET quantity = quantity + 20 WHERE Id=1

Try:

Try:

-- @addNewQuantity is the new value sent for update. 20 here. 
UPDATE 
  MtTable
SET
  Quantity = Quantity + @addNewQuantity