in reply to MS SQL Server & PERL :: Data Getting Rounded

If these are really, truly ID numbers (randomly assigned and having to other purpose in life that to be used as keys into the Data Base), then they should be defined as a character-string, not as numeric data.

Think about it, when was the last time you added together your Master-Card number and your Visa number? The fact that a piece of data consists entirely of numbers does not automatically mean that it is a meaningful number subject to the whims of Arithmetic and Algebra.

----
I Go Back to Sleep, Now.

OGB

  • Comment on Re: MS SQL Server & PERL :: Data Getting Rounded

Replies are listed 'Best First'.
Re^2: MS SQL Server & PERL :: Data Getting Rounded
by glasswalk3r (Friar) on Oct 27, 2009 at 23:41 UTC

    Or, if you can't modify how data is stored in the table(s), just modify the stored procedure to convert the numbers to characters.

    Alceu Rodrigues de Freitas Junior
    ---------------------------------
    "You have enemies? Good. That means you've stood up for something, sometime in your life." - Sir Winston Churchill