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