T-SQL COALESCE Example

T-SQL COALESCE SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your expression.  For example, I want to return the products in the AdventureWorks sample database and show the SellEndDate if…

ROW_NUMBER SQL Server

Row_Number SQL Server SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number() function.  You can use this function to return a sequential number in your result set that begins at 1.…

Azure SQL Server Database

SQL Server in Azure You can create and leverage cloud based SQL Server instances using Microsoft Azure.  However, if you have never used the Azure portal it can be a bit challenging to get started.  This post will show you…