Now, THAT'S what I'm talking about! The use of brackets, though optional, is one of the rules of...

Jeff Moden (4/6/2009)

---

The "good enough" attitude in the face of schedule pressures is the frequent cause of unneccessary rule of thumb violations. My answer to such violations is "prove...

OK, you got me there!:-P However, I was referring...

I also got this wrong because I thought that the second choice would also result in a null, so I expanded on the code a bit to test each condition:

DECLARE...

David Walker (4/3/2009)

---

Although this is off the original topic, I still haven't seen a SQL statement that was easier to read with the aliases than without them. Please show...

No. NO!!! NO!!!! The table name itself is the most accurate representation of what's being joined. ...

When you go to a toolbox, not the one in your IDE but a real one that holds a wrench, hammer, screwdriver and the like, do you pick up the...

katedgrt (4/3/2009)

---

Grow up and learn that different is not always bad and new is not always better. I mean there is a point to keeping up your skills and...

Jason Miller (4/3/2009)

---

I couldn't agree more. While it may be a pain to type in the "extra"...

I think it all comes down to a paradigm. Folks who spend most of their time in an object-oriented environment tend to think in those terms. The same...

My dad always told me that too much of anything, even a good thing, can be bad for you. I can't think of any example that is more applicable...

It's about 25 UDF/SP files and the dependencies are not always direct. While I really wanted to have a "click it and forget it" approach, I just may have...

That allows one to execute a SQL file from a .BAT file (requiring a connection to the database for each file), but what about within an existing SQL file that...

J (3/17/2009)

---

I strongly object to such obfuscated programming. How many beginners who subscribed to this forum could be misled into thinking "wow ! clever trick I've got to find an...

I agree with the earlier statement that the choice of a procedure named "GO" was a red herring. That has NOTHING to do with the GO separator. The procedure...