Daniel Bowlin (8/4/2011)
Implicit conversion is one of those issues, where if you know it, you just know. If you don't know it, the result is very unexpected. I am learning more and more of these, but I wonder, is there a singular document reference that lists all the implicit conversions that happen in SQL Server?
There absolutely is!
http://msdn.microsoft.com/en-us/library/ms187928.aspx
It lists all the conversions that can happen Implicitly and those that can not.