So I was writing a script to pull out some old xml data, and I happened upon this error:
XML parsing error: An invalid character was found in text content.
It probably would have taken me centuries to figure out what character it didn't like, so I tried concatenating the following line to the front of the xml column in the SELECT statement I used to populate the cursor for openxml, and voila, no more error! I guess bumbles really do bounce.
'<?xml version=''1.0'' encoding=''iso-8859-1''?>'
I've officially eliminated the alarm clock from my daily awakening. I discovered a few years ago that if I look at the clock and tell myself that I want to wake up from a nap at a specific time, I would actually wake up at the correct time about 95% of the time. I've extended that to a full night's sleep the past couple weeks, though I haven't been taking note of the current time when I've gotten into bed. All I do is tell myself I want to wake up at 7:02 AM, for example, and I do. I don't really think I'm special, I think anybody could do it.
This is great:
"For the president to perform his constitutional duties, it is imperative that he receive candid and unfettered advice and that free and open discussions and deliberations occur among his advisors," Fielding said.
How is this not an admission that people in the executive branch are saying things the public wouldn't want to hear? I guess the question is just how bad these things are, but my guess is they're things that would get the president impeached. Not that there are any presidents who haven't said something behind closed doors that would get them impeached.
Havarti is the key to a great tuna salad sandwich. Diced celery is also a wonderful addition.
I can't believe I just discovered the last_altered column in information_schema.routines in SQL Server 2005, all this time I thought there was no way to get the last modified date for a stored procedure. Is there a catch?
Is Christmas really boring for the 7% of males who are red-green colorblind?
If you don't want to waste a lot of time figuring out why the results of your OPENXML query are all NULL, never forget that it's case sensitive. I'm sure it's already obvious to those who use XML often and are acutely aware that it's case sensitive, but if you spend most of your time doing SQL you tend to forget about case sensitivity.