If I have a script like this:

SELECT MyTable.MyField FROM MyDatabase.dbo.MyTable WHERE MyTable.AddDate>'2011/03/22 17:08:26'

...it executes instantly. The result is zero record.

But, if I parameterize it such as:

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.

I tried to make the declaration char and nvarchar but that did not help.

There is something I am missing here.