Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Decimal field width inconsistency
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01523093
Message ID:
01523094
Vues:
50
>Hello,
>
>I create a table in MsSQL with
>
>CREATE TABLE Test (test Decimal(10,0))
>
>
>When I query from this table
>
>SQLEXEC(1,"SELECT * FROM Test","cuTest")
>
>Then the field Test.test is 12 decimals.
>How can that be, and how can I avoid this inconsistency?

see what your set(Decimals) is set to.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform