Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Decimal field width inconsistency
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01523093
Message ID:
01523095
Views:
41
>>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.

Decimals is set to 2. Changing it to 0 does not seem to have any effect on the result.
Christian Isberner
Software Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform