触发器

选择字号： 超大 标准 发布时间：2009-8-24 1:56:42 | 作者：admin | 0个评论 | 人浏览

  CREATE   TRIGGER   onPlanMo1Delete   ON   [dbo].[PlanMO1]    
  FOR   DELETE    
  AS  
  declare   @MoNo   varchar(20),  
                            @line   smallint;  
  declare   #aa   cursor   for   select   mono,line   from   deleted  
  open   #aa  
  fetch   next   from   #aa   into   @mono,@line  
  while   @@fetch_status=0  
  begin  
          IF   (SELECT   PKQty+PKQtyL   FROM   PlanMO2   WHERE   PMONO=@MoNo   AND   PMoLine=@line)>0  
          Begin  
                  rollback   transaction  
                  return  
          end  
   
          IF   (SELECT   PKQty+PKQtyL   FROM   PlanMO2   WHERE   PMONO=@MoNo   AND   PMoLine=@line)=0  
          Begin  
                  DELETE     from   PlanMo2   where   PMONO   =@MoNo     AND   PMoLine=@Line  
          end    
          fetch   next   from   #aa   into   @mono,@line  
  end  
  close   #aa  
  deallocate   #aa  
 

标签：TRigger  

猜你喜欢

• 触发器012009-8-24 1:58:8