TSQL: Some interesting usages of Coalesce

The coalesce function is a really powerful function that can help us in various scenarios. It is described in this MSDN document so I am not going to discuss its working in this post. Instead, I will only present a few interesting usages. <ul> <li>Calculating overrideable attributes</li> <li>Combining results from Full Outer Join</li> <li>String concatenation</li> </ul>