TSQL: Some interesting usages of Coalesce(smehrozalam.wordpress.com)

submitted by mehrozmehroz(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>

add a comment |category: |Views: 31

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story