I have a nicely setup site setup running coldfusion and a lot of queries. I have it setup so that all queries point to a variable. That way I can change the datasource the site calls on with 1 line.

So I am getting ready to go from access (current) to sql server. I am getting familiar with enterprise manager and all those apps that are used there, but I am just wondering about the sql structures. Is it likely that most of my queries will work with no change? How much different are the 2 sql languages?

I am going to test it out later, but I am just curious if there is some tips and such for the process of going from one to the other.