coalesce Archives - SQLRelease

Avoid Use of While Loops to get a Comma Seperated list of rows

1 Comment / SQL Server / Gopal Krishna Ranjan / Sep 8, 2014 / coalesce, row concatenation, set based approach

Problem Detail In the morning at your workplace, your manager or any colleague comes to you and asks to get the list of all the dates in a comma separated list. Now the first and the quickest way of getting the output which will knock us is using a loop to get the list. In […]

Avoid Use of While Loops to get a Comma Seperated list of rows Read More »

Be aware when using ISNULL

ISNULL vs COALESCE in SQL Server In our T-SQL programming, we mostly use ISNULL function to replace the null value of a column with another value. The same can be achieved using COALESCE function too. In this blog post, we are going to see a significant difference between NULL and COALESCE functions. We are going to