One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?
2021-08-16
3,386 reads
2018-05-18
961 reads
2016-01-29
1,670 reads
Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.
2015-11-25
4,572 reads
2013-09-20
2,701 reads
2013-06-03
2,588 reads
2012-11-09
2,196 reads
2012-10-17
2,489 reads
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,591 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Will Assaf
On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...
Last week, Kerry and I delivered a webinar with tips on how to set...
So I have a SQL 2017 server that has the two Report Server Databases,...
I knew about the position of SQL Developer through an introductory newspaper. I found...
i work on SQL server 2012 I face issue i can't update table replacement...
Ask SSC