触发器问题？

 
  CREATE   TRIGGER   Group_History  
   
  ON   GroupLocalArrange  
   
  FOR   UPDATE  
   
  AS  
   
  --******************************************************************  
   
  BEGIN  
   
   
  INSERT   INTO   GroupLocalHistory(id,groupID,localDate,localTraffic,gatherPlace,residence,eat)  
   
  SELECT   id,groupID,localDate,localTraffic,gatherPlace,residence,eat  
   
  FROM   deleted  
   
  ----这样只能插入一条信息，但我想插入多条信息。这个插入语句怎么写？  
  ----我想插入GroupLocalArrange表中所有符合GroupLocalArrange.groupID=deleted.groupID条件的记录到GroupLocalHistory表中~  
   
   
  END  
   
  请高手指点指点，我是菜鸟~ 问题点数：20、回复次数：6Top

1 楼yingjm（）回复于 2004-09-01 10:56:51 得分 5

INSERT   INTO   GroupLocalHistory(id,groupID,localDate,localTraffic,gatherPlace,residence,eat)  
   
  SELECT   id,groupID,localDate,localTraffic,gatherPlace,residence,eat  
   
  FROM   deleted，GroupLocalArrange   where   GroupLocalArrange.groupID=deleted.groupIDTop

2 楼yesterday2000（一笑而过）回复于 2004-09-01 10:57:13 得分 8

 
  CREATE   TRIGGER   Group_History  
   
  ON   GroupLocalArrange  
   
  FOR   UPDATE  
   
  AS  
   
  --******************************************************************  
   
  BEGIN  
   
   
  INSERT   INTO   GroupLocalHistory(id,groupID,localDate,localTraffic,gatherPlace,residence,eat)  
   
  SELECT   b.id,b.groupID,b.localDate,b.localTraffic,b.gatherPlace,b.residence,b.eat  
   
  FROM   deleted   a,GroupLocalArrange   b  
  where   a.groupID=b.groupID  
   
  ENDTop

3 楼yingjm（）回复于 2004-09-01 10:57:47 得分 5

INSERT   INTO   GroupLocalHistory(id,groupID,localDate,localTraffic,gatherPlace,residence,eat)  
   
  SELECT   id,groupID,localDate,localTraffic,gatherPlace,residence,eat  
   
  FROM   GroupLocalArrange   where   groupID   in   (select   groupid   from   deleted)Top

4 楼SDLin（临贫人）回复于 2004-09-01 11:18:07 得分 0

 
  这样不行  
   
  SELECT   b.id,b.groupID,b.localDate,b.localTraffic,b.gatherPlace,b.residence,b.eat  
   
  FROM   deleted   a,GroupLocalArrange   b  
  where   a.groupID=b.groupID  
   
  有多个值，这样也能插吗？Top

5 楼ouyld（ゎたしすきぁぉた）回复于 2004-09-01 12:04:40 得分 1

UPTop

6 楼zhushizu（从来就没有救世祖）回复于 2004-09-01 13:01:44 得分 1

是呀，我也是想了好久。。关注中。。。Top

相关问题

• gatherplace
• localtraffic
• localdate
• groupid
• grouplocalarrange
• grouplocalhistory
• residence
• eatfrom
• eat
• 插入

• 帖主：SDLin
• yingjm
• yesterday2000
• yingjm
• ouyld
• zhushizu

• SQL Server类图书