Microsoft Transact SQL Reference

 

sql azure

Microsoft TSQL Reference Online:

https://docs.microsoft.com/en-us/sql/t-sql/language-reference

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

Reminder to self on select usage in SQL:

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-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.

Types:

https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql

Conversion Functions (cast, convert, parse):

https://msdn.microsoft.com/en-us/library/hh231076.aspx

Working with NULL:

https://docs.microsoft.com/en-us/sql/t-sql/functions/isnull-transact-sql

Expressions:

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/expressions-transact-sql

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

https://courses.edx.org/courses/course-v1:Microsoft+DAT201x+2T2017

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:

https://github.com/MicrosoftLearning/QueryingT-SQL