sql server data warehouse: which datatype? -- sql server data warehouse

which datatype?

anonymous NO[at]SPAM discussions.microsoft.com
4/27/2004 8:37:48 AM

sql server data warehouse: I want to store a load of numeric value to 2 decimal
places, i.e. 28.65

I have been reading my SQL server guide, trying to decide
on the best datatype to use, but I have just got more
confused...

Can someone tell me which to use...

decimal, float, real, money, small money or numeric?
My guess is decimal with precision of 2. Is that right? Is
the precision the no. of decimal places?

Also, does anyone know of an online guide which explains
them all, with sample data for each?

thanks

Nick

Re: which datatype?

Allan Mitchell
4/29/2004 8:55:08 AM

If you look in BOL at this page

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_de-dz_3grn.htm

it says that in your example you have

Precision = 4
Scale = 2

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]