Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Something's wrong with numeric data
Message
De
05/03/2003 10:15:43
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00761481
Message ID:
00761488
Vues:
32
>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
Fil
Voir

Click here to load this message in the networking platform