March 6, 2009 at 7:56 am
hi im using sql server 2000 query analyzer and for some reason the integer fields from the tables are being displayed as floats e.g. 10 is displayed as 10.00 even though the table field is defined as integer. The field is displayed as normal integer if viewed from enterprise manager. Any ideas ... is it a setting on QA or something?
March 13, 2009 at 10:05 am
In Query Analyzer, from the Tools menu select Options.
Go to Connections tab.
Unclick Use regional settings when displaying currency, number, dates and times.
That might fix it.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
March 13, 2009 at 2:39 pm
How are you querying the data. You could be causing an implicit CAST.
March 16, 2009 at 7:39 am
JacekO (3/13/2009)
In Query Analyzer, from the Tools menu select Options.Go to Connections tab.
Unclick Use regional settings when displaying currency, number, dates and times.
That might fix it.
That has done the trick! - Thanks very much! 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply