Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Something's wrong with numeric data
Message
From
05/03/2003 10:15:43
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00761481
Message ID:
00761488
Views:
33
>Hi everybody,
>
>I want to have a field with 2 decimal points. The default value for this field is 0.05
>
>I tried numeric and decimal (both are identical anyway according to Help), but my default value is not working. I set precision to 2.
>
>It shows 0 instead when I open table and see all rows.
>
>What is my problem?
>
>Thanks in advance.

Works for me. Did you added the column after the fact?

What's your column definition? (Create Table syntax)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform