AS [ IF UPDATE ( column ) [ UPDATE ( column ) ] sql语句; 下面展现一个insert触发器 create trigger tr_COMMISSIONINFO_INSERT on COMMISSION_INFO_ for insert as begin declare @COMMISSIONID varchar(20),@DATE datetime set @COMMISSIONID=(select ID_ from INSERTED) set @DATE=getdate() insert into COOPERATE_YEARS_(COMMISSION_ID_, CONTRACT_START_DATE_, RE_CONTRACT_START_DATE_) VALUES(@COMMISSIONID, @DATE, @DATE) end 希望我的回答对你有所帮助,祝你好运!