News

Ars Technica

SQL Syntax for Updating datetime Field

I just added a field, 'ExportDate' to a table (AYP) in my MS SQL 2000 database. Since I added the field to an existing table, the values for 'ExportDate' in all records is <null>.<P>What I need to do ...
Ars Technica

SQL/ASP - Comparing current date and time to Date/Time fields from MS Access 2002 db

I'm getting syntax or type mismatch errors when trying to build/execute an SQL query to compare the current date and time to a date/time field in an MS Access 2002 database. I have seemingly used ...