Have you checked out the MSDN site? Search for T-SQL and you can find lists of commands and what they do. There is also good developer centric information too. If your employer will pay for it, check out getting a MSDN subscription.

http://msdn.microsoft.com/en-us/default.aspx