Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SmallInt vs numeric
Message
From
05/07/2011 20:18:25
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: SmallInt vs numeric
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01517359
Message ID:
01517360
Views:
54
>Hi,
>
>If you need to have a column that will store values from 0 to 5 (maybe 10 at the most) what is a better type: Smallint or Numeric(1,0)?
>
>TIA.

Tinyint.
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform