Other than database performance (which in my my experience is not too greatly different in either) the only real improvement between sql and access is stored procs (which are great).
Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.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]
