Microsoft Transact SQL Reference


sql azure

Microsoft TSQL Reference Online:

A little more official than just random search on web and stackoverflow.

Reminder to self on select usage in SQL:

  1. SELECT statements are written with the following clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
  2. The query engine processes the clauses in this order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.


Conversion Functions (cast, convert, parse):

Working with NULL:


I am doing an Edx & Microsft refresher on SQL here, so come join me in the learning journey:

I figure this is a good idea, as I learned most of my SQL via trial and error on a work project.

Course Source Code on Github: