Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data type for percent value Expand / Collapse
Author
Message
Posted Thursday, June 30, 2011 3:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 11, 2011 6:11 AM
Points: 17, Visits: 39
Hi Experts,

I would like to define a data type in table for saving percent value. For instance a valuesuch as 0.96 or 0.96% which data type will fit?

Thanks
mtraore
Post #1134308
Posted Thursday, June 30, 2011 3:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:31 AM
Points: 11,194, Visits: 11,137
DECIMAL(5,2)



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1134311
Posted Thursday, June 30, 2011 6:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 11, 2011 6:11 AM
Points: 17, Visits: 39
Many Thanks
Post #1134381
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse