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

Click here to load this message in the networking platform