What's wrong with w3schools, never get the hate, it's an ok site, code on it seems fine.
I do use w3schools for SQL syntax though - I haven't found any better resource for this, and generally Google gives me MSDN articles about TSQL which are usually of no use to me.