SQLServer触发器当⼀个字段值修改时,修改当前数据其他字 段值
create TRIGGER testtrigger --触发器名称
on tb --表名
after update --更新触发
as
andidaif update (column1) --当column1字段被更新时,才会触发此触发器
BEGIN
SET NOCOUNT ON;
DECLARE @a VARCHAR (20) --定义变量 SET @a = (SELECT d.ida
FROM
deleted d,
鸟的祖先inserted i
WHERE
d.ida = i.ida
update tb set test = 'g2' where ida = @a --执⾏的操作
end
create TRIGGER [dbo].[billtrigger]
on [dbo].[ICStockBill]
after update --更新触发
as
if update (FStatus) --当FStatus字段被更新时,才会触发此触发器
BEGIN
SET NOCOUNT ON;
DECLARE @a VARCHAR (20) --定义变量
SET @a = (SELECT
d.FInterID
液压元件FROM
deleted d,
inserted i
发泡材料WHERE
d.FInterID = i.FInterID
) --变量赋值,到对应更新的那⼀⾏。
班杜拉update ICStockBillEntry set FEntrySelfB0457 =竟拍网
(select b.FQty from ICInventory b
where ICStockBillEntry.FItemID = b.FItemID
and ICStockBillEntry.FSCStockID=b.FStockID)
where finterid =@a
end