接着问问题

CREATE     trigger   insert_yuanshidata_trigger   on   yuanshidata   after   insert  
  as  
  declare   @sTelNO   char(12),  
  @sMsg       varchar(200),  
  @sKaoHao   char(20),  
  @sTName     char(30),  
  @sFather   char(30),  
  @tKaTime   datetime,  
  @ZaoShangT   datetime,  
  @ZhongFangT   datetime,  
   
   
  @ZhongFangOverT   datetime,  
  @ZhongShangT   datetime,  
  @XiaFangT   datetime,  
  @sXueName   char(40)  
  select   @sXueName=school_name   from   inserted  
  select   @ZaoShangT=zaoshangxue,@ZhongFangT=wufang,@ZhongFangOverT=wufangend,@ZhongShangT=wushang,@XiaFangT=xifang   from   schoolinfo   where   school_name=@sXueName  
   
  select   @sTelNO=telno,@sKaoHao=kahao,@sTName=stname,@sFather=father,@tKaTime=katime   from   inserted  
   
  if   @tKaTime<@ZhongFangT  
  BEGIN  
  set   @sMsg=Rtrim(@sFather)+'家长你的孩子'+Rtrim(@sTName)+Convert(Varchar(20),@tKaTime,120)+Rtrim('到校')  
   
  END  
   
  if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=ZhongFangOverT  
   
  BEGIN    
  set   @sMsg=Rtrim(@sFather)+'家长你的孩子'+Rtrim(@sTName)+Convert(Varchar(20),@tKaTime,120)+Rtrim('离校')  
  END  
   
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<XiaFangT  
   
  BEGIN    
  set   @sMsg=Rtrim(@sFather)+'家长你的孩子'+Rtrim(@sTName)+Convert(Varchar(20),@tKaTime,120)+Rtrim('到校')  
  END  
   
  if   @tKaTime   >@XiaFangT  
   
  BEGIN    
  set   @sMsg=Rtrim(@sFather)+'家长你的孩子'+Rtrim(@sTName)+Convert(Varchar(20),@tKaTime,120)+Rtrim('离校')  
  END  
   
       
  --回滚rollback   transaction    
   
  语法检查老是提示我ＺhongFangOverT   XiaFangT   无效的列名 问题点数：100、回复次数：5Top

1 楼hsj20041004（光芒）回复于 2005-04-27 13:01:01 得分 60

是不是你的语句写错了(丢了个@)??  
  if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=ZhongFangOverT  
  应该是  
  if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=@ZhongFangOverT  
  还有  
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<XiaFangT  
  应该是  
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<@XiaFangT  
  Top

2 楼xluzhong（Ralph）回复于 2005-04-27 13:02:40 得分 20

时间对比  
  if   @tKaTime<@ZhongFangT  
  ----change  
  if   (datediff(ms,@tKaTime,@ZhongFangT)>0)Top

3 楼paoluo（一天到晚游泳的鱼）回复于 2005-04-27 13:04:16 得分 20

if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=ZhongFangOverT  
   
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<XiaFangT  
   
  少了@，加上。  
   
  if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=@ZhongFangOverT  
   
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<@XiaFangT  
  Top

4 楼paoluo（一天到晚游泳的鱼）回复于 2005-04-27 13:08:15 得分 0

 
  if   @tKaTime<@ZhongFangT  
  改为  
  if   DateDiff(d,@tKaTime,@ZhongFangT)<0  
   
  if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=ZhongFangOverT  
  改为  
  if   DateDiff(d,@tKaTime,@ZhongFangT)>=0   And   DateDiff(d,@tKaTime,@ZhongFangOverT)<=0  
   
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<XiaFangT  
  改为  
  if   DateDiff(d,@tKaTime,@ZhongFangOverT)>0   And   DateDiff(d,@tKaTime,@XiaFangT)<0  
   
  if   @tKaTime   >@XiaFangT  
  改为  
  if   DateDiff(d,@tKaTime,@XiaFangT)>0  
  Top

5 楼xluzhong（Ralph）回复于 2005-04-27 13:14:42 得分 0

if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=ZhongFangOverT  
  --change  
  if   @tKaTime   >=@ZhongFangT   and   @tKaTime<=@ZhongFangOverT  
   
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<XiaFangT  
  --changge  
  if   @tKaTime   >@ZhongFangOverT   and   @tKaTime<@XiaFangT  
  Top

相关问题

• tkatime
• zhongfangovert
• zhongfangt
• xiafangt
• stname
• sfather
• datetime
• rtrim
• datediff
• char

• 帖主：anlun
• hsj20041004
• xluzhong
• paoluo

• SQL Server类图书