返回修改前后的指定字段的值及批量修改表数据
1、返回修改前后的指定字段的值
update rrl_user set h_money = h_money + 1 OUTPUT isnull(Inserted.h_money, 0) Inserted,
isnull(deleted.h_money, 0) deleted WHERE id = 19088; --返回修改后的值,返回修改前的值
2、批量修改表数据
UPDATE
rrl_goods
SET
beans_pay_rate = beans,
cash_pay_rate = cash
FROM rrl_goods, test_goods_20180705
WHERE test_goods_20180705.goods_id = rrl_goods.id