Nice SQL Table, nice kitty
-
If you think you have it bad... My company uses tables with 300+ fields, and it just gets larger and larger with time. Apparently this people haven't heard of normalisation. Grrrr :Misery Loves Company: X| X| Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark TwainNotorious SMC wrote: My company uses tables with 300+ fields :eek: X| Must be fun writing stored procedures for those tables :-D 300 parameters later I would be ready to skin a cat with a pickle brush.
Paul Watson
Bluegrass
Cape Town, South Africa -
Notorious SMC wrote: My company uses tables with 300+ fields :eek: X| Must be fun writing stored procedures for those tables :-D 300 parameters later I would be ready to skin a cat with a pickle brush.
Paul Watson
Bluegrass
Cape Town, South AfricaI might have been exagerating a bit....It's just 2-4 tables that has 300+ fields, the rest have a more manageble fields of about 100 ;P Anyway, I'm the R&D department now, so I don't have to ever look at those database again!! :jig: ~life is good :)~ Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain -
The worse that I've seen is char 10's being used as a PK for no reason other than "we've always done it this way" and some rilly, rilly clever individual spending the day working out a practical use for his sort-by-guid stored procedure. Run, RUN! Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
my svg article -
The worse that I've seen is char 10's being used as a PK for no reason other than "we've always done it this way" and some rilly, rilly clever individual spending the day working out a practical use for his sort-by-guid stored procedure. Run, RUN! Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
my svg articleSimonS wrote: sort-by-guid stored procedure :laugh: :laugh: :laugh: Oh classic. A GUID sorter, hilarious :-D
Paul Watson
Bluegrass
Cape Town, South Africa -
You think that's bad? Some of our customers use a product called Visma, which they need linked to their e-commerce site. As a typical example, the price table has 94 columns, most of which allow null, with wonderful names like "SDc2P", "Un", etc. Guess who gets the job of writing the interface? Nice photos, BTW. Planning a new career? :-D
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
You think that's bad? Some of our customers use a product called Visma, which they need linked to their e-commerce site. As a typical example, the price table has 94 columns, most of which allow null, with wonderful names like "SDc2P", "Un", etc. Guess who gets the job of writing the interface? Nice photos, BTW. Planning a new career? :-D
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Richard Deeming wrote: with wonderful names like "SDc2P", "Un", Un? LOL, ouch. My sympathies. Richard Deeming wrote: Nice photos, BTW. Planning a new career? :-O Thanks. I need to be a lot better before I can make it into a career though :)
Paul Watson
Bluegrass
Cape Town, South Africa -
Roger Wright wrote: God made a jackass for practice, then He made a school board. Samuel Clemens Mark Twain fan ? ;) Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark TwainNotorious SMC wrote: Mark Twain fan ? Absolutely!:-D His "The Innocents Abroad" provides some excellent examples of good reasons why the people of the middle East despise Americans. "How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
-
David Wulff wrote: Seriously reconsidering the meaning of life? More like the life of the chap who made this table *dot, dot, dot* :laugh:
Paul Watson
Bluegrass
Cape Town, South AfricaPaul Watson wrote: More like the life of the chap who made this table *dot, dot, dot* :laugh::laugh: Regards, Brian Dela :-)
Run naked in the snow until you're sweating like a stuck pig and can't seem to catch your breath. When the flu becomes pneumonia, they can cure that with a shot. - Roger Wright -
Oh, I see it so often I put a recommendation about this in my article[^] I see dumb people
