[thelist] MS SQL datatype question

Tim Gaunt info at thesitedoctor.co.uk
Thu May 24 00:22:36 CDT 2007

Jeffrey Barke wrote:
> Are you sure scale and precision have been set correctly?

Yes that's important, check how you're defining the decimal in the table's
structure, you'll need to set its decimal places and precision -decimal(p,
d) where p is the total number of digits, with d of them after the decimal
place i.e. decimal(8, 1) should cover what you need (passing in 1.52 would
result in 1.5)


We’re doing a 96 mile canoe race (the Cheshire Ring Race) on June 30th in
aid of charity and I’m going to keep pimping the message out shamelessly
until we reach our target of £2,000! For more information –or to donate– go
to www.paddlathon.co.uk

More information about the thelist mailing list