505.369.1650 [email protected]

SQL differences between MS SQL Server and MS Access

by | Apr 27, 2009 | Microsoft Access, Microsoft SQL Server, SQL | 0 comments

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).

Making Microsoft Access Work

No matter what your MS Access needs are, Carl can provide live help to make sure you get the solution you need.

GET LIVE HELP

Submit a Comment