SP OUTPUT - SP Return Value - Scalar Function - Table Function - Table Value Parameter - Index
more examples | continue | const | foreach | while | for
Group by - RollUp - Cube - Grouping - Pivot - Exec - SP - Function
if - else - switch - case - for - while - do while - Random - break
Union - Exists - MAXRECURSION - Window Function - Row Number - Rank - Dense Rank - NTile