Access To SQL

I am in the middle of migrating an app from Access to SQL Server and I'm in a desperate need of some relevant articles on SQL queries differences between those. 

For instance:

 <% msql = "SELECT * FROM InnerMessages WHERE InnerMessages.DateRead is Null AND InnerMessages.To='"& Session("UserName") &"'"
Set RS1 = Server.CreateObject("ADODB.Recordset")
RS1.Open msql, MyConn, 1,3 %> works with acces,but returns the error:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'To'.

on SQL Server. And there are several others...

you will need to change the field called To to something else, IE messageTo, as To is a reserved keyword.