Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SmallInt vs numeric
Message
 
 
To
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:
01517387
Views:
52
>>>>>>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!

The language on this forum is going to heck.
Previous
Reply
Map
View

Click here to load this message in the networking platform