Microsoft TSQL Reference Online:
A little more official than just random search on web and stackoverflow.
Reminder to self on select usage in SQL:
- SELECT statements are written with the following clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
- 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: