505.369.1650 [email protected]

Here are some differences in how SQL is written in Microsoft SQL Server versus Microsoft Access.

  • Update query syntax is different.
  • Use + instead of & in queries.
  • Use ‘ around a date instead of #.
  • Use GetDate() instead of Date().
  • Use CASE x THEN y ELSE z END instead of IIF(x,y,z).

A complete list of differences between Microsoft Access SQL and Transact SQL can be found in the article Comparing Access SQL with SQL Server TSQL.