Rounding In Query Analyzer... 1

[flaniganmj]

If a SQL Server 2000 table looks like this:

PK Value
-- ------
1 3.6456

where PK=int and Value=decimal(15,4)


Why would...

 select
   Value Value0, 
   Convert(varchar(20),Value) Value1
 from
   table
 where
   PK=1

...return the following in Query Analyzer...
[tt]
Value0 Value1
------ ------
3.65 3.6456
[/tt]

And...

 declare @p decimal(15,4)

 select 
   @p=Value 
 from 
   table 
 where 
   Value=1

 print @p

...will print
[tt]
3.6456
[/tt]

Additionally, when using the value in a calc it is rounding first???

Regards,

mjf

 

[JamesLean]

In QA, go to Tools -> Options -> Connections tab and uncheck "Use regional settings..." option.

--James

 

[flaniganmj]

thank you

Thanks,

flan