Here are three free online tutorials:

http://www.sql-tutorial.net/

http://www.firstsql.com/tutor.htm

http://www.w3schools.com/sql/default.asp

These are the primary Microsoft SQL Server References:

SQL Server 2000 Books Online

http://msdn2.microsoft.com/en-us/library/aa257103(SQL.80).aspx

SQL Server 2005 Books Online

http://msdn2.microsoft.com/en-us/library/ms130214.aspx