你可以按如下方式制作程序。

You can make procedure as follows.

ALTER PROCEDURE [dbo].[DeductAmountFrom1]
@Amount Decimal -- assumed amount is type of decimal
AS
BEGIN
   --scenario 1--
   --tablename == table which needs to update
   --amountcol = column which needs to update
   --filter condition == updation criteria
   --tablename2 ==  insertion required table
   --[column1,columns2] other columns name
   --insertamountcol == insertion required column name
   --[other columns value] ==other columns values

   Update tablename
   set
   amountcol= amountcol-@Amount
   where [filter condition]

   Insert into tablename2
   ([column1,columns2], insertamountcol]
   VALUES ([other columns value], @Amount);

END