No matter how bad the code I get from a new hire, they're never shown the door for it. Instead, I'd show them an explanation. The best source of...

Ok Hugo, My last point, because the Qotd, I agree, its nice to see challenging things.

But the answer; Simply changing the SQL to Exists makes the whole...

Hugo, Conventions & parsing aside. Are we to believe that someone would write something so convoluted to demonstrate Exists/Not Exists Syntax ( select(1=1))

I mean it doesn't even make...

Am I missing something here ?

The query has a BUG in it it has nothing to do with 1=1

Declare @customer Table ( ID int

...

>I am amazed at how many applications I see with a stored procedure that has a single record being updated >in a single table and nothing to correctly lock the...

Read the way the question was worded, it was very specific:

>To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?

Notice the...

is this a licensing question or is this an upgrade question. Because I can get MSDE databases upgraded to SS2005 any edition. Anytime. 

I stoppped subscribing to it when you started having to log in. I bought the magazine because of the website

quote:

---

All in all...