If you have done your code using ANSI SQL, then it will pretty much work. If you have used Access specific Jet SQL statements, then you will need to modify these for Transact SQL. This includes things like syntax, functions, type conversion... E.G. NOT in Transact SQL is ~
You also have various advantages with Transact SQL and SQL Server that you do not have in Access.... User defined functions, Stored Procedures, Triggers, coalition, schedules, full text searching to name a few. HTH Russ Michaels Macromedia Certified ColdFusion Professional CFMX Hosting - Macromedia ColdFusionMX Hosting Phone: 0845 456 3487 Tech Support: 0906 9607800 FAX: 0709 2212 636 WEB: www.cfmxhosting.co.uk Helpdesk: www.cfmxhosting.co.uk/helpdesk ---------------------------------------------------------------------------- ----------------------- Please use the support helpdesk on our web site to submit support tickets. Join our ColdFusion Developer discussion lists and forums at www.cfdeveloper.co.uk. ---------------------------------------------------------------------------- ----------------------- > -----Original Message----- > From: Jolly Green Giant [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 01:40 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SQL compared to Access backend > > So how different is your code when your backend is SQL Server > rather than Access? I've worked in Access for 4 years. What > can I expect to be different if I want to work in SQL? Most > simple queries will stay the same, won't they? > > I know some functions may change, but what else? > > Thanks! > > David /jgg > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
