Date handling between the two is quite different. Also, SQL Server has T-SQL, which has a vast library of somewhat useful functions.
Also, I don't think Access has CASE.. WHEN.. THEN.. ELSE.. END ----- Original Message ----- From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 12:58 PM Subject: RE: SQL Syntax > 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? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
