Prev: SQL2000: Permissions Stored Procedures
Next: Option(RECOMPILE)
From: Robert Lakinski on 9 Mar 2010 15:43
Dave Ballantyne" <symlink(a)no5p323mmer> wrote in message
news:eKyKmf4vKHA.2436(a)TK2MSFTNGP04.phx.gbl...
> Careful of these SARG's. This will more than likely cause tablescans

Agree. This one is better:

Select ..
from ..
where DDate between cast (getdate() - 2 as int) and cast (getdate()-1 as
int)

Robert


First  |  Prev  | 
Pages: 1 2
Prev: SQL2000: Permissions Stored Procedures
Next: Option(RECOMPILE)