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...

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 and anything that has to do with them scares me. I say this because if something goes wrong with them usually you...

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 feat...

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 messages among others....

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...

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 means that you have...

C# String PadLeft() and PadRight()

This has been an irritating method to use especially when you don’t use it too often. Here are some tips about using PadLeft() and PadRight(). First off it is not a static method, you need...