TSQL: Some interesting usages of Coalesce(smehrozalam.wordpress.com)
submitted by
mehroz(185) 1 year, 9 months ago
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>
|category: Database
|Views: 31
tags:
Database another
Everyones tags:
Your Tags: