| Author |
Topic |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2005-05-16 : 10:18:37
|
| Is it just me or does it seem that we have a rash of questions that boil down to poor table structures?Example: “I have this table and I store the entry date in a varchar field called date”JimUsers <> Logic |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-16 : 10:27:40
|
Was that from the snitz people ?  DamianIta erat quando hic adveni. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-16 : 10:52:04
|
| INSERT TaskSchedule( TaskID, ScheduledDate )VALUES( 'check database design', 'tomorrow' )Can't wait 'til SQL Sever Express is officially released into the hands of every .net programmer...rockmoose |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-16 : 11:04:40
|
oh yeah.... can you imagine:for (i=0;i<(select count(*) from MyTable);i++){ str = str + columnToCsv[i] + ",";}in a sproc  ok i know it doesn't work this way but you get the point...Go with the flow & have fun! Else fight the flow |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-18 : 04:30:36
|
| Sometimes you can't do anything about it. The d/b I babysit isn't even in first normal form!! I can't change it as it would breach the contract with the supplier. It drives me mad having to work around it and to make things worse we have a 'bright young thing' who I am trying to teach some skills and all he has to work on is this so there is a danger he'll learn some of the bad habits.To be fair to the supplier (not sure why I should be) the system is a straight conversion from the PICK system which I believe used multi line fields or something and so wasn't entirely relational (and would have been poorly designed in there). Anyone remember it? I believe it's still going particularly in Oz. I understand it's quite a good system that never took offA sarcasm detector, what a great idea. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-18 : 18:09:03
|
| Yeah, I used to work on a system that was a PICK derivative. I wrote about my experience on my SQLTeam blog.---------------------------EmeraldCityDomains.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-05-19 : 07:05:28
|
| Ha! You youngsters!One of the 3rd party DBs I look after (a document management system) uses a database that was originally written for architects drawings. The names of columns and tables have not been changed, so all the queries look ridiculous. Maybe its some deliberate form of copy-protection obfuscation ...Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-19 : 18:59:32
|
| Hey old timer - how long does it take to type all those punch cards you must be pretty good after all that practice. I bet you can even use more than two fingers these days :)steveA sarcasm detector, what a great idea. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-05-26 : 02:27:35
|
| Two fingers? You have to rotate the dial, choose the letter, and then thump it with the ball of your hand ...... good news is if you get it wrong you can put one of the cut-outs back and run over it with a Biro so that it stays put.Kristen |
|
|
|
|
Poor Table Structures