Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SmallInt vs numeric
Message
From
05/07/2011 21:51:51
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01517359
Message ID:
01517366
Views:
55
>>>>>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.
>>>
>>>Excellent. Thank you.
>>
>>MinisculeInt might also be a good fit.
>
>That would be a tinyint bit too small though.

A tinyint bit? Shit!
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform