the query slow?

• lundi 17 octobre 2011 11:29

   

   
  

  0

  declare @date01 date

  declare @date02 date select @date01=convert(varchar(10), dateadd(day,13,DATEADD(YEAR,-1,GETDATE())),120)

  select  @date02=convert(varchar(10), dateadd(day,1,@date01),120)

  
  select top 500 * from t
  where dtime >@date01 and dtime <@date02,the query is very slow，
  ；but like this, where dtime >‘2011-11-1’ and dtime <'2011-11-2',the query is quickly,why? 

  • Réponse
  • Citation