触发器找bug :)

补充一下：这几个参数都是本触发器的局部变量，本触发器是由另外一个触发器触发。CREATE TRIGGER deletePlan ON dbo.tblPLAN 
AFTER DELETE 
AS
BEGIN
DECLARE 
@varPlnName varchar(100),
@varPlnType varChar(100),
@varPlnStartTime datetime,
@varPlnEndTime datetime,
@varPlnFeedback varchar(2000),
@varPlnOpposite  varchar(2000),
@varPlnComments varchar(2000),
@varPlnUserId    integer,
@varPlnLnkId    integer,
@varPlnProId integer,
@varPlnAccId integerSELECT @varPlnName =plnName,
@varPlnType =plnType,
@varPlnStartTime =plnStartTime,
@varPlnEndTime =plnEndTime,
@varPlnFeedback =plnFeedback,
@varPlnOpposite=plnOpposite  ,
@varPlnComments =plnComments,
@varPlnUserId =plnUserId   ,
@varPlnLnkId =plnLnkId   ,
@varPlnProId=plnProId ,
@varPlnAccId =plnAccId
FROM DELETEDIF (@varPlnUserID=NULL ) OR (@varPlnLnkId =NULL ) OR (@varPlnProId=NULL) OR (@varPlnAccId=NULL) 
BEGIN
RETURN 
ENDINSERT INTO tblHISTORY(hisName,hisType,hisStartTime,hisEndTime,hisFeedback,
hisOpposite,hisComments,hisUserId,hisLnkId,hisProId,hisAccId)
 VALUES(@varPlnName,@varPlnType,@varPlnStartTime,@varPlnEndTime,@varPlnFeedback,@varPlnOpposite,@varPlnComments,@varPlnUserId,@varPlnLnkId,@varPlnProID,@varPlnAccId)END