General information
Forum:
Microsoft SQL Server
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only