Now() Equivalent in MSSQL
Use the Getdate() function in SQL Server instead of Now() in Access (and MySQL, I think).
Wow, it's shocking to see the limits of "standardized SQL".
Tags: date, time, database, mssql, sql server, tsql, function
>> Leonard Chan's Homepage
>> Scribble Web
>> Now() Equivalent in MSSQL