DotNetShoutout - TSQL: Some interesting usages of Coalesce « Mehroz’s Experiments

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

6
Shouts

Shout it

TSQL: Some interesting usages of Coalesce « Mehroz’s Experiments

published 664 days, 10 hours, 39 minutes ago posted by

mehroz 665 days, 9 hours, 36 minutes 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.

Calculating overrideable attributes
Combining results from Full Outer Join
String concatenation

category: SQL | clicked: 0 | | source: smehrozalam.wordpress.com | show counter code

tags: coalesce, TSQL, transact sql

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout