compare integer numric

[baran121]

hi everybody,

i wanna learn which is better to use ?

my data will be maximum 4 digit
so numeric(4) or smallint . which one i should use?

is there any good article about it.

thank you.

 

[bborissov]

Smallint - 2 bytes
Numeric(4) - 5 bites


Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[baran121]

so i should use numeric(4)
thank you very much.

 

[simian336]

Hey Boris,

Is that a typo... BOL says

numeric[ (p[ , s] )]
Fixed precision and scale numbers. When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1.

Precision Storage bytes
1 - 9 5

Simi

 

[SQLBill]

The most important thing to consider is the type of numbers you will store. Will any have decimal places? If so you can't use the INT data type (including SMALLINT and BIGINT).

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[bborissov]

What typo?
precision 4 - 5 bites

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[gmmastros]

Here's the proof:

Declare @NumericVariable Numeric(4)
Set @NumericVariable = 0
Select DATALENGTH(@NumericVariable)

Declare @SmallIntVariable SmallInt
Set @SmallIntVariable = 0
Select DATALENGTH(@SmallIntVariable)

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom