Skip to content

Obscure Problems and Gotchas

If you couldn't find your answer to your weird problem, you might find it here.

  • About
  • Application Errors Hall of Shame
  • DyslexicApps
Development, Gotcha, SQL Server

Padding a string in tSQL

by: admin2019-02-04

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 […]

Gotcha, SQL Server

Sql Server REPLACE function makes expression string NULL when replacement string is NULL

by: admin2018-02-05

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 […]

Uncategorized

SSRS Report Viewer Control Broken Image Below Lines – Missing URL parameter: IterationId

by: admin2012-11-08

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. […]

Uncategorized

Entity Framework: Executing SQL Strings

by: admin2012-09-01

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 […]

Uncategorized

Telerik RadGridView Column Format Calamity

by: admin2012-06-07

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 […]

Uncategorized

SQL Server: String or binary data would be truncated.

by: admin2012-04-30

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 […]

Uncategorized

How to convert a String (Char Array) to List of Int (ASCII Decimal Equivalent)

by: admin2012-02-22

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 […]

Uncategorized

C# String PadLeft() and PadRight()

by: admin2011-11-10

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(). […]

Search posts

Happy find? Help me buy the coffee that fuels these articles!

Like what you are reading?

It takes time to write these quality blog posts and sometimes software. Maybe something I have written has benefited you? Blog posts can take anywhere from a few minutes, to a couple of hours, to several days to construct. Software is a constant work in progress. Want to help me buy my next bag of coffee?

Anything is appreciated

Categories

Recent Comments

  • Paloma on DataGridView Loses Formatting and Columns After Setting DataSource a Second Time
  • Caleb on MVC CSHTML partial view loses all syntax highlighting/color during rename operation; then copy, cut or paste operations cause Visual Studio errors to be thrown
  • Rilwan on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • admin on Biases in naming database objects
  • Alberto D. Sarubbi on Biases in naming database objects

Archives

Search posts

Search posts

SSL Secure

Copyright © All rights reserved. Theme Creativ Mag by Creativ Themes