客户有3个关联表做触发器要求sql server 和mysql都需要
1、sql server触发器:
CREATE TRIGGER ld_ticketcf_a
ON ld_ticketcf
FOR INSERT
AS
declare @a varchar(50) ,@ticketid int,@accountid int,@account_no varchar(100),@accountname varchar(100);
select @ticketid = ticketid, @a = (SELECT top 1 accountname from ld_account s1 where s1.account_no = (select top 1 accountid from ld_troubletickets s2 where s2.ticketid = inserted.ticketid) ) from inserted
BEGIN
UPDATE ld_ticketcf
SET a= @a where ticketid = @ticketid
END
2、mysql触发器:
DROP TRIGGER ld_ticketcf_a
CREATE TRIGGER ld_ticketcf_a BEFORE INSERT ON ld_ticketcf
FOR EACH ROW
BEGIN
SET NEW.a = (select accountname from ld_account s1 where account_no = (select accountid from ld_troubletickets s2 where s2.ticketid= NEW.ticketid));
END;