decimal (28,2)

microsoft.public.sqlserver.programming

14 Jul 2006 8:51 AM

Martin

I have defined my decimal fields with decimal (11,2). I have also defined
parameters in VB.Net where I set SqlDBType.decimal without setting a size or
precision ().

When I look at the statement using SQL Profiler, my decimal parameters are
set to decimal (28,2) and (28,0).

Is this so, because I have not defined any size or precision in my
parameters and thus a default setting from SQL Server? But why then the
difference (28, 2) vs. (28, 0)?

14 Jul 2006 9:26 AM

According to Books Online teh default precision is 18 and the default scale 0.
=> decimal(18, 0)

ML

---
http://milambda.blogspot.com/