Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Forcing Scale to a Minimum of 2 Digits
Message
De
18/02/2002 14:01:15
Jason Dalio
Northern Interior Regional Health Board
Prince George, Colombie Britannique, Canada
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Forcing Scale to a Minimum of 2 Digits
Divers
Thread ID:
00621612
Message ID:
00621612
Vues:
46
I have a co-worker who is having difficulty with SQL Server 7. With the numeric or decimal data types you can specify your scale and that sets the maximum digits. If you enter the value 5.30 into a row it is stored as 5.3. That makes sense form the database point of view. However, she wants it to actually store as 5.30. Is there a way to do this without having to use currency or text (nvarchar, char, etc.)? She doesn't want to have to alter her reports just to have everything line up in a nice format every time. I suggested building a view on the table but is there a way around this?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform