CREATE TRIGGER EAS.trName  
 NO CASCADE BEFORE insert //插入觸發(fā)器 
 ON eas.T_user  
 REFERENCING NEW  AS N_ROW //把新插入的數(shù)據(jù)命名為N_ROW 
 FOR EACH ROW MODE DB2SQL //每一行插入數(shù)據(jù)都出發(fā)此操作 
BEGIN ATOMIC //開(kāi)始 
DECLARE U_xtfidemp1 varchar(36); //定義變量 
DECLARE u_xtempcode1 varchar(20); 
DECLARE u_xtempcodeCount int ; 
DECLARE U_xtfidempCount int ; 
DECLARE u_id1 int ; 
set U_xtfidemp1=N_ROW.U_xtfidemp;//把新插入的數(shù)據(jù)賦值給變量 
set u_xtempcode1=N_ROW.u_xtempcode; 
set u_id1=N_ROW.u_id; 
 set u_xtempcodeCount= (select count(u_xtempcode) from eas.T_user where u_xtempcode is not null and u_xtempcode=u_xtempcode1 and u_id<>u_id1); 
 set U_xtfidempCount=(select count(U_xtfidemp) from eas.T_user where U_xtfidemp is not null and U_xtfidemp=U_xtfidemp1 and u_id<>u_id1); 
 IF u_xtempcodeCount>0 or U_xtfidempCount>0 THEN 
　　    SIGNAL SQLSTATE '80000' ('eas.T_user Exceeds u_xtempcode,U_xtfidemp 插入數(shù)據(jù)時(shí)有錯(cuò)誤,有重復(fù)'); 
　　END IF; 
END 

CREATE TRIGGER EAS.trName  
 for insert //插入觸發(fā)器 DB2 寫(xiě)法 NO CASCADE BEFORE insert  
 ON eas.T_user  
  //SQL Server沒(méi)有 把新插入的數(shù)據(jù)命名為N_ROW REFERENCING NEW  AS N_ROW 
   //SQL Server沒(méi)有  FOR EACH ROW MODE DB2SQL  
BEGIN // SQL Server沒(méi)有  ATOMIC //開(kāi)始 
DECLARE @U_xtfidemp1 varchar(36); //定義變量 DB2 寫(xiě)法 沒(méi)有@ 
DECLARE @u_xtempcode1 varchar(20); 
DECLARE @u_xtempcodeCount int ; 
DECLARE @U_xtfidempCount int ; 
DECLARE @u_id1 int ; 
//set U_xtfidemp1=N_ROW.U_xtfidemp; 
//set U_xtfidemp1=N_ROW.U_xtfidemp 
//set u_xtempcode1=N_ROW.u_xtempcode; 
 -- 從inserted臨時(shí)表中獲取記錄值 //把新插入的數(shù)據(jù)賦值給變量 
  select @U_xtfidemp1 = U_xtfidemp, 
      @u_xtempcode1 = u_xtempcode, 
      @u_id1 = u_id  
      from inserted 
 set @u_xtempcodeCount= (select count(u_xtempcode) from eas.T_user where u_xtempcode is not null and u_xtempcode=@u_xtempcode1 and u_id<>@u_id1); 
 set @>U_xtfidempCount=(select count(U_xtfidemp) from eas.T_user where U_xtfidemp is not null and U_xtfidemp=@U_xtfidemp1 and u_id<>@u_id1); 
 IF@u_xtempcodeCount>0 or @U_xtfidempCount>0 THEN 
　　  //  SIGNAL SQLSTATE '80000' ('eas.T_user Exceeds u_xtempcode,U_xtfidemp 插入數(shù)據(jù)時(shí)有錯(cuò)誤,有重復(fù)');　　 END IF; 
END