Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow […]
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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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(). […]