Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Decimal field width inconsistency
Message
From
09/09/2011 12:32:26
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Decimal field width inconsistency
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01523093
Message ID:
01523093
Views:
99
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?
Christian Isberner
Software Consultant
Next
Reply
Map
View

Click here to load this message in the networking platform