34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TIGGER TEST ON A
FOR UPDATE
AS
IF EXISTS(SELECT 1 FROM A WHERE ZFBZ='F')
BEGIN
INSERT INTO B(BLH , ZYCS ,ZFSJ) SELECT I.BLH , I.ZYCS ,GETDATE() FROM INSERTED AS I INNER JOIN A ON
I.BLH=A.BLH AND I.ZYCS=A.ZYCS
END
CREATE trigger tr_tabA
on taba
after update
as begin
if update(zfbz)
begin
insert into tabb
select blh,zycs,getdate()
from inserted where zfbz='f'
end
end