Get 15 minutes of free Live Help!

SQL differences between MS SQL Server and MS Access

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
read more

posted on: Apr 27, 2009 | author: Carl Connett

Live Chat Software