SELECT MyTable.MyField FROM MyDatabase.dbo.MyTable WHERE MyTable.AddDate>'2011/03/22 17:08:26'...it executes instantly. The result is zero record.
DECLARE @Date datetime SET @Date='2011/03/22 17:08:26' SELECT MyTable.MyField FROM MyDatabase.dbo.MyTable WHERE MyTable.AddDate>@Date...it takes a while. And, the result is still zero record.