jcrawf02 (9/21/2010)

---

david_wendelken (9/21/2010)

---

blandry (9/8/2010)

---

...and we call this progress. For me, looking over my decades in the business, its two steps forward, a hundred backwards as we layer complexity where...

I could be wrong but I don't think this is new to 2012 - I think the OP was just specifying a single known version for accuracy. Pretty sure...

I agree, great article. Any technical specialist who can combine their knowledge with the ability to write and speak clearly is going to be a lot more effective!

Hugo Kornelis (10/17/2012)

---

The explanation is wrong, though. The innermost COALESCE does NOT return "a typed NULL", but a non-NULL string value (that just happens to be equal to the string...

Thanks for this - an interesting post with at the very least some excellent starting points for thinking about databases in different ways.

That said (with regards to your section on...

Thanks - definitely something that most developers should have come across (many times!) in the course of their career but also captures something important about implicit conversion in SQL Server.