Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query Analyzer shows integer-results as decimal
Message
De
17/04/2005 08:54:01
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Query Analyzer shows integer-results as decimal
Divers
Thread ID:
01005557
Message ID:
01005557
Vues:
150
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)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform