触发器

CREATE TRIGGER [TRIGGER_ZWNFF_FF_FCRSTORFCINF]
ON [dbo].[P_RIVER_F]
AFTER   INSERT
AS
declare   @PJCD  varchar(11)
declare   @STCDT  varchar(10)    

select   @PJCD   =  PJCD , @STCDT = STCDT from  inserted f, P_NODE e
where f.ndcd = e.ndcd

begin
 insert into ZWNFF_FF_FCRST (fc_id,stcd,fc_time,qfin,qfalt)
 select f.PJCD,e.STCDT,f.YMDHM,f.Q,f.QControl from inserted  f, P_NODE e
 where f.ndcd = e.ndcd
end

if not exists  (select * from ZWNFD_FF_FCINF where fc_id =  @PJCD and stcd =  @STCDT )
 begin
  insert into ZWNFD_FF_FCINF (fc_id,stcd,bgn_time,end_time)  
  select  f.PJCD,e.STCDT,min(f.YMDHM) as strattime,max(f.YMDHM) as endtime
  from P_RIVER_F  f, P_NODE e where f.ndcd = e.ndcd   and   PJCD =  @PJCD and STCDT =  @STCDT
  group by f.PJCD,e.STCDT  order by f.PJCD,e.STCDT
 end
else
 begin
  update ZWNFD_FF_FCINF
  set 
  bgn_time =( select min(f.YMDHM) as tempstrattime  from P_RIVER_F  f, P_NODE e where f.ndcd = e.ndcd  and  PJCD =  @PJCD and STCDT =  @STCDT),
  
  end_time =( select max(f.YMDHM) as  tempendtime  from P_RIVER_F  f, P_NODE e where f.ndcd = e.ndcd  and PJCD =  @PJCD and STCDT =  @STCDT )
  where  fc_id =  @PJCD and stcd =  @STCDT
 end

 

自己程序中用到了，写了个触发器，插入多条数据时，判断是否存在重复数据