Sql Server REPLACE function makes expression string NULL when replacement string is NULL
Obscure problem This has happened to me before, but naturally I forgot because it has been a while. The scenario is that you have dynamic SQL and you are trying to replace tags in your SQL string with...
SSRS Report Viewer Control Broken Image Below Lines – Missing URL parameter: IterationId
I know it is unreasonable for me to say this but AXD files (HTTP Handlers) and anything that has to do with them scares me. I say this because if something goes wrong with them usually you can’t...
Entity Framework: Executing SQL Strings
I’ve griped about this before, not sure why everything has to be so complicated with EF at times, but holy hell executing just a simple SQL String “SELECT * FROM Table” is a major fe...
Telerik RadGridView Column Format Calamity
Wow… just wow. I lost about an hour trying to figure out a: TargetInvocationException: Exception has been thrown by the target of invocation. This is probably one of the most useless exception m...
SQL Server: String or binary data would be truncated.
Msg 8152, Level x, State x, Line x String or binary data would be truncated. What does this mean? This is the equivalent of SQL Server telling you that you are trying to fit too much into a container ...
How to convert a String (Char Array) to List of Int (ASCII Decimal Equivalent)
I think it confuses people that single characters are interchangeable with byte and int, so here I am telling you that they are interchangeable up to an ASCII limit of 128 characters. This m...