Helping you outshine the competition

Differences between Access and SQL Server from a ColdFusion perspective

The following information is provided as-is without warranty of any kind to visitors to act as a resource for ColdFusion and related development. They are NOT meant to be a full-fledged tutorial on an subject, but rather a brief overview of specific scenarios involving a typical problem and a ColdFusion solution.

Problem

You are upgrading your database type from Access to SQL Server, and must modify the ColdFusion code to reflect these changes

Cheatsheet

Access	SQL Server	Notes
SELECT DISTINCTROW	SELECT DISTINCT	No duplicate rows
LIKE "cat"	LIKE "%cat%"	Wildcards is * or %
DELETE * FROM tablename	DELETE FROM tablename	Leave out the * when you are deleting rows from SQL Server
Now()	GetDate()	Current date/time
Instr()	CharIndex()	Searching a string
Ucase()	Upper()	Upper case
Lcase	Lower()	Lower case
Trim()	Rtrim(ltrim())	Removing extre spaces
int(x)	convert(int,x)	Convert to integer
A & B	A + B	String concatenation operator

Back to Code Snippets
 

Related Links

Microsoft SQL Server page
Official SQL Server page

MD CF User's Group - Upgrading to SQL Server Tutorial
Includes sections on reasons to upgrade and copying your data to the new environment