Comment On Classics Week: Chocolate Covered SQL

Dup?

I'm sorry, I'm missing something here. Whats the SQL refrence?

Timmy:

Dup?

Thus the "Classic Week" Title!

WTF? Can't anyone here read?

someone:

I'm sorry, I'm missing something here. Whats the SQL refrence?

Look at the jpeg. right after the ingredients listing.

someone:

I'm sorry, I'm missing something here. Whats the SQL refrence?

its a package you would get in a store. rather than saying like Made from Facility 5, the sql code was returned rather than the data it would of returned. silly!!!

Haha!

* may contain sql queries

SQL is so 1990s, where's my MDX chocolate?!?

awesome!!!

Instant classic!

Packed in an environment where Gluten, Nuts, Sesame seeds and slightly dodgy SQL code may be present.

:P

SomeoneElse:

Timmy:

Dup?

Thus the "Classic Week" Title!

WTF? Can't anyone here read?

Perhaps they should idiot-proof it and change the title from Classics Week to We know these have been posted before, but we're re-running some oldies but goodies so please STFU week

SomeoneElse:

Timmy:

Dup?

Thus the "Classic Week" Title!

WTF? Can't anyone here read?

Yes, I love candy!

The real, uh, failure is that they seem to be using an Access DB.

Sweet!

This one was my favorite. I remember reading it as I was writing a query.

/captcha smile
:D

lol, thats funny

"idiot proof it"

No, just say: "Classics week! To report dups, bang head here --> * "

Frito-Lay has a new dip that includes the ingredient DATEM.

Yeah, I know it is an emusifier, but it always looks like a print code error to me.

Oh, and just for clarity... we are selecting from a TABLE... SELECT * FROM Equipment just wasn't clear enough.

igitur:

Oh, and just for clarity... we are selecting from a TABLE... SELECT * FROM Equipment just wasn't clear enough.

They kept having problems with that syntax. The database server kept instructing the assembly line robots to physicially SELECT pieces of equipment from the room. It wouldn't have been so bad, except that it turned out to be a blocking read, since the robot would lift the equipment from its moorings to indicate its "selected" status.

The current syntax is scarcely better, though. When one robot Selects the [Equipment Table], the other robots don't have anywhere to put their error printouts before photographing them.

Stephen:

* may contain sql queries

Haha, nice. Anyway, if they're gonna go for "classic" articles, they should go for articles from before this year, no?

That's not SQL, that's MS SQL and there's a big difference. One's a standard the other is as incompatible with that standard as possible while plausibly retaining the name. It bears a passing resemblance at best.

shadowman:

SomeoneElse:

Timmy:

Dup?

Thus the "Classic Week" Title!

WTF? Can't anyone here read?

Perhaps they should idiot-proof it and change the title from Classics Week to We know these have been posted before, but we're re-running some oldies but goodies so please STFU week

Perhaps they could just change is using a find and replace?

You know, like when you click http://thedailywtfthedailywtfthedailywtf.worsethanfailure.com/Default.aspx

Note my find, of course, but damn funny.

Saarus:

shadowman:

SomeoneElse:

Timmy:

Dup?

Thus the "Classic Week" Title!

WTF? Can't anyone here read?

Perhaps they should idiot-proof it and change the title from Classics Week to We know these have been posted before, but we're re-running some oldies but goodies so please STFU week

Perhaps they could just change is using a find and replace?

You know, like when you click http://thedailywtfthedailywtfthedailywtf.worsethanfailure.com/Default.aspx

Note my find, of course, but damn funny.

Damn... s/Note/Not/ in previous post.

Did anyone else notice the space in the table name and the space in the column name????

Bryan:

Did anyone else notice the space in the table name and the space in the column name????

Yip. Not very elegant, but totally permissible, hence the square brackets around the names.

Bill Joy:

That's not SQL, that's MS SQL and there's a big difference. One's a standard the other is as incompatible with that standard as possible while plausibly retaining the name. It bears a passing resemblance at best.

I think that allowing spaces in tables/columns is the most horrible idea evar! evar!

doof:

"idiot proof it"

No, just say: "Classics week! To report dups, bang head here --> * "

A wise man once taught me:
"Don't waste your time trying to make things idiot proof. Instead, aim to make them fool resistant."

Troy Mclure:

Bill Joy:

That's not SQL, that's MS SQL and there's a big difference. One's a standard the other is as incompatible with that standard as possible while plausibly retaining the name. It bears a passing resemblance at best.

I think that allowing spaces in tables/columns is the most horrible idea evar! evar!

lol, true. But it's not a big difference. Just use the current ansi standards and don't use spaces. voila. (although CTPs are handy)

igitur:

Oh, and just for clarity... we are selecting from a TABLE... SELECT * FROM Equipment just wasn't clear enough.

Huh? What's wrong with this? I know I always do:

void fooFunction(void);

struct barStruct;

class foobarClass;

int fubarInteger;

float fuFloat;

someTypeClass barfooObject;

On a related note, I also like the following typedefs in C:

#define ONE 1
#define TWO 2
#define THREE 3
#define FOUR 4

BillyBob:

On a related note, I also like the following typedefs in C:

#define ONE 1
#define TWO 2
#define THREE 3
#define FOUR 4

Obviously too early in the morning as these are clearly not typedefs :-)

Say what, bill?

If MSSQL isn't <a href="http://www.dbazine.com/db2/db2-disarticles/gulutzan3">standard enough</a> for you, who is?

IBM and Oracle hardly implement a perfect SQL1999 or SQL2003 either.

In fact, I don't know that <a href="http://troels.arvin.dk/db/rdbms/">anyone</a> implements a complete "standard" SQL (and if so, which version? 99? 2003? 92? earlier?)

(Don't like the T-SQL extensions? Nobody's forcing you to use them - MS won't make you, as near as I can tell.)

Only database I know that even tries to implement something other than SQL_old standard is www.nexusdb.com.

Sigivald:

Say what, bill?

If MSSQL isn't <a href="http://www.dbazine.com/db2/db2-disarticles/gulutzan3">standard enough</a> for you, who is?

IBM and Oracle hardly implement a perfect SQL1999 or SQL2003 either.

In fact, I don't know that <a href="http://troels.arvin.dk/db/rdbms/">anyone</a> implements a complete "standard" SQL (and if so, which version? 99? 2003? 92? earlier?)

(Don't like the T-SQL extensions? Nobody's forcing you to use them - MS won't make you, as near as I can tell.)

Only database I know that even tries to implement something other than SQL_old standard is www.nexusdb.com.

So, the WTF is that they used SELECT *, instead of enumerating the column names, right?

No, the WTF is that SQL code is showing up on packaging.

Anonymous:

So, the WTF is that they used SELECT *, instead of enumerating the column names, right?

Serpardum:

No, the WTF is that SQL code is showing up on packaging.

Thanks for enlightening him on that one dude, I think you really made a difference in someone's life today

TheRider:

Sweet!

Dude!

Saarus:

Perhaps they could just change is using a find and replace?

You know, like when you click http://thedailywtfthedailywtfthedailywtf.worsethanfailure.com/Default.aspx

Note my find, of course, but damn funny.

Click... Click... Click... Doesn't do anything.

No One:

TheRider:

Sweet!

Dude!

Sweet!

Derby is the most SQL compliant DB I've dealt with. IIRC, it's SQL92 they use, but it's been a while so I don't remember.

SomeoneElse:

Timmy:

Dup?

Thus the "Classic Week" Title!

WTF? Can't anyone here read?

Ever get the feeling that some people might be trying to be funny by saying these posts are repeats?

What's mine say?!?

*:

No One:

TheRider:

Sweet!

Dude!

Sweet!

What's mine say?

<That I am an idiot that can't quote correctly ;)>

Yeah, with the bracketed, space-containing field names, it's got to be Microsoft SQL Server or MS Access. I think the semicolon at the end clinches it for Access.

Smitty:

someone:

I'm sorry, I'm missing something here. Whats the SQL refrence?

its a package you would get in a store. rather than saying like Made from Facility 5, the sql code was returned rather than the data it would of returned. silly!!!

Would _have_ returned. But other than that, yes.

The wtf for me is, this is all I see:

Toby Gray, that's just not fair! How come my chocolate covered raisins never come with any SQL?

Is there supposed to be an image or something? If it's an external link, I'm betting it's Websensed.

Websense. It so makes me want to get back to work.

JV:

The wtf for me is, this is all I see:

Toby Gray, that's just not fair! How come my chocolate covered raisins never come with any SQL?

Is there supposed to be an image or something? If it's an external link, I'm betting it's Websensed.

Websense. It so makes me want to get back to work.

I've never tried this but ... apparently you can drop a url into Bablefish's "Translate a Web page" data entry box, select Russian to English and, when the fish translates the page, it doesn't appear to be coming a Websense-banned site.

I'm just saying.

(not first; not telling you my captcha; not end-of-file)

SELECT * FROM comments WHERE article = 'Classics Week: Chocolate Covered SQL'

Wow, if the Quality Control is this good for the packaging, imagine how good the chocolates are!