Posted by Erland Sommarskog on 07/22/05 18:52

Fernand St-Georges (fernand.st-georges@videotron.ca) writes:
> I got the value I needed using this type of query
> WHERE (dbo.Membre.Date_MAJ > GETDATE() - 1) AND (dbo.Membre.Date_MAJ <
> GETDATE() + 1)
> I only thought this would do
> where date_MAJ = GETDATE()
>
> while in Access I only need
> where date_MAJ =DATE()
>
> kind of amazing isn't it

No, it's not all amazing. Access and SQL Server are two very different
products, and if you try to use SQL Server as if it was Access you
are in for a hard time.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]