有两个表:一个是dingdan(ddid,sfzb) 一个是baojia(bjid,ddid,xz) 当修改了baojia中的xz,当改成1时,订单中的sfzb项要修改成“是” 麻烦,给个触发器,来触发,谢谢create trigger trg_baojia_upt on baojia for update as update dingdan set sfzb='是' from dingdan join inserted on dingdan.ddid=inserted.ddid where inserted.xz=1
CREATE TRIGGER tr_baojia ON baojia FOR INSERT, UPDATE AS If UPDATE(xz) BEGIN declare @ddid Nvarchar(100),@s datetime select @ddid = ddid,@s = xz from inserted if @s = '1' exec('update dingdan set sfzb = ''是'' where ddid = ''' + @ddid + '''') END go
一个是baojia(bjid,ddid,xz)
当修改了baojia中的xz,当改成1时,订单中的sfzb项要修改成“是”
麻烦,给个触发器,来触发,谢谢create trigger trg_baojia_upt on baojia
for update
as
update dingdan set sfzb='是' from dingdan join inserted on dingdan.ddid=inserted.ddid where inserted.xz=1
ON baojia
FOR INSERT, UPDATE
AS
If UPDATE(xz)
BEGIN
declare @ddid Nvarchar(100),@s datetime select @ddid = ddid,@s = xz from inserted
if @s = '1'
exec('update dingdan set sfzb = ''是'' where ddid = ''' + @ddid + '''')
END
go