[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)
HTH
Tim
---------------------
Were doing a 96 mile canoe race (the Cheshire Ring Race) on June 30th in
aid of charity and Im 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