Information générale
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)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement