There is a lot of information in the world that people just assume is true because it has been repeated so much. Twinkies have an unlimited shelf life. McDonalds hamburgers have so many preservatives, they will never get moldy. The problem is this information is frequently wrong. But the incorrect information is so widespread and […]
I ran into some unexpected behavior with local variables that I think should be pointed out. Normally, local variables can only be declared once in a query. For example, this code: produces this error: Msg 134, Level 15, State 1, Line 2 The variable name ‘@TestInt’ has already been declared. Variable names must be unique […]
I’ve been bitten twice recently by my reliance on faulty assumptions. I’m sure we all remember the old adage that when you assume you make an ASS out of U and ME. Well, I have certainly proven the truth in that saying lately. (Ok, maybe I only made an ass out of me and not […]