I thought it might be useful to start a semi-regular series of entries on troubleshooting for the SQL Server developer. Google has come to my rescue lo, these many times: this is my way of returning the favor. For this first entry I thought I’d tackle one of the more mysterious-looking runtime errors I see Read more »
Tag Archives: Troubleshooting
Data Type Conversions with Coalesce and IsNull
One topic I have spoken on a few times in the past few months, but have not elaborated on a great deal, is the issue of bugs caused by data type conversions when using the IsNull expression in T-SQL. This is a relatively subtle issue, though, and deserving of some attention, so I thought I Read more »