There are two differences that I am aware of:
1. when doing multiple table joins using INNER JOIN or OUTER JOIN you must
use nested parenthesis in ACCESS but not in SQL Server
2. the system date. In ACCESS it is NOW() and in SQL Server it is
GETDATE()
I don't think you'll find any other differences between the two.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 10:46 AM
To: CF-Talk
Subject: SQL Syntax
Question,
Does Access have different SQL syntax than SQL Server?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
