Transact-SQL (T-SQL) may just be the most popular query language in the world. T-SQL is compliant with industry standards (read the details at https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-sqlstandlp/89fb00b1-4b9e-4296-92ce-a2b3f7ca01d2) and has a very rich extension from standard Data Manipulation Language (DML) and Data Definition Language (DDL) statements. You can see the complete T-SQL reference guide at https://aka.ms/tsql.
One of the areas that T-SQL excels at is providing a rich ...