SmallInt vs numeric - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SmallInt vs numeric

Message

05/07/2011 20:22:55

Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis

05/07/2011 20:20:57

Dmitry Litvak
Massachusetts, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: SmallInt vs numeric

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01517359

Message ID:

01517363

Vues:

>>>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.

Very fitting: http://xkcd.com/386/

Répondre

Fil

Voir

Click here to load this message in the networking platform