Register  Login
Home

Live Help

Training & Support

Snippets & Tips

Contact Us
Snippets & Tips
***NEW CUSTOMER OFFER***
Get 15 minutes of free Live Help!
Coupon Code: 20110729  
Live Help
Snippets & Tips Categories Minimize
  

Search Snippets & Tips Minimize
  

Notes

Some operating systems block files that come from other computers.  If you cannot get a downloaded file to work properly, right-click over the file, select the Properties option, and then click the Unblock button at the bottom of the General tab.
  

View Code Snippets & Tips Minimize

SQL differences between MS SQL Server and MS Access

Apr 27

Written by: Extra Mile Data
4/27/2009 10:56 AM 

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

Trackback Print
Location: Blogs MS SQL Server
Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 
  

Extra Mile Data - Go Faster...Go Further!

Go Faster...Go Further!  Call (479) 524-8479.
Extra Mile Data, your source for Microsoft Access help
Terms Of Use | Privacy Statement | © 2003-2011 Extra Mile Data