SQL Server Programming

SQL Server Functions

Integer sequence generator, Date sequence generator

Nested case when statement

Case when statement in Order by clause

EXECUTE sp_executesql

Partition by Clause

Pivot Table and Unpivot Table

CTE (Common Table Expression)

Access denied for user 'ODBC'@'localhost' (using password: NO)