Your Daily Cup of WTF

An actual table from a production database. The client code uses it (I believe) by opening a recordset to it and extracting the field names. What's puzzling is that the system isn't a database schema tool, or anything like that. Just a plain old boring information system.

What I still can't figure out ... why are the columns not named intInt, and dtmDatetime :-)?

Published Monday, May 17, 2004 2:36 PM by Alex Papadimoulis
Filed under:

Comments

Monday, May 17, 2004 2:55 PM by Jim Bolla

# re: Your Daily Cup of WTF

WTF is right. I am curious as to what it's actually being used for. If they needed schema info on datatypes, why not use sql's built-in functionality to get it? select * from systypes ...there it is. no need for some magic table. the original developer should be given a wedgie or purple nurple or some other form of gradeschool abuse.
Monday, May 17, 2004 3:03 PM by jakeypoo

# re: Your Daily Cup of WTF

well, how else will you get a list of the possible datatypes? i mean, besides the fact that any programmer probably has them memorized already, the pull down menu that lets you select the data type, help files, books online, ...
Monday, May 17, 2004 10:11 PM by RegisteredTM

# re: Your Daily Cup of WTF

or have a table with

strDataType, strDataTypeDesc?
Sunday, February 25, 2007 6:53 AM by meee

# re: Your Daily Cup of WTF

wow the first  wft. Now i feel part of history! :P

Sunday, February 25, 2007 6:35 PM by Pop!

# Must... resist...!

I have a terrible, shameful urge to point at the first DailyWTF and shout... "FIRST!"

Monday, February 26, 2007 3:08 PM by DanixDefcon5

# re: Your Daily Cup of WTF

OMFGWTFBBQ!!

Heh. The first WTF. The one that started it all. w00t!!!