rounding in sql

12 May 2005 3:10 PM

Ben Wallace (3)

Can anyone provide any links or information about the differences in
rounding between access 97 and sql 2000.

12 May 2005 11:17 PM

Mary Chipman [MSFT]

See
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B196652.

--Mary

On Thu, 12 May 2005 10:10:28 -0500, "Ben Wallace \(3\)"
<kix***@excite.com> wrote:

Show quote

>Can anyone provide any links or information about the differences in
>rounding between access 97 and sql 2000.
>

13 May 2005 3:25 AM

--CELKO--

You might also like to know that truncation and rounding at
implementation defined in Standard SQL.

13 May 2005 8:58 AM

Tibor Karaszi

> You might also like to know that truncation and rounding are
> implementation defined in Standard SQL.

I find that weird. Doesn't that limit portability a lot? Or at least increase test time? What was
the rational behind making it implementation defined? Vendors couldn't agree because of current
implementation?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"--CELKO--" <jcelko***@earthlink.net> wrote in message
news:1115954756.702609.23790@o13g2000cwo.googlegroups.com...
> You might also like to know that truncation and rounding at
> implementation defined in Standard SQL.
>