Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Analyzer shows integer-results as decimal
Message
From
17/04/2005 10:01:26
 
 
To
17/04/2005 08:54:01
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01005557
Message ID:
01005560
Views:
25
This message has been marked as the solution to the initial question of the thread.
>I've installed a developer version of SQL Server 2000.
>
>
>select * from dbo.streetsXpost
>   where munid = 101 and streetid = 1662 and postalid = 1439
>
>
>results in
>
>101,00	1.662,00	1.439,00
>
>But all the fields are smallint or integer.
>
>What to set?
>
>BR
>
>Peter
SQL QA >>> Options >> Connections >> Apply International .... >> uncheck
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform