Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Analyzer shows integer-results as decimal
Message
From
17/04/2005 08:54:01
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Query Analyzer shows integer-results as decimal
Miscellaneous
Thread ID:
01005557
Message ID:
01005557
Views:
151
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
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Next
Reply
Map
View

Click here to load this message in the networking platform