AARRRRGGGGGHHHH!!!! Microsoft has done it again!! Taken a perfectly useful and STANDARD coding practice and beat it with an ugly stick.

All you MySQL guys out there… Remember when you first tried to put a string into a SQL statement which included a contraction in it? That damn apostrophe got in the way! So, you likely learned about escaping characters. If you want to put an apostrophe into a SQL statement you had to escape it with the escape character “\”. So, any “special” characters had to be escaped: quotes, single quotes, new lines, tabs, etc…

I’ve learned today that Microsoft’s version of escaping these characters for MSSQL would be doubling up on them. Well, at least for the DAMN apostrophe. How do you escape an apostrophe? You just use two of them side by side. God damn it… IDIOTS. HATE HATE HATE HATE!!!

Disclaimer: I’m still new to ASP.NET so there is a remote chance I’m full of crap. But, I’m still DAMN ANGRY!