Re: Data Type

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 11:10:48 -0500

Are they going to be whole numbers? If so, there is little benefit to
making them numeric, unless you know you will exceed the capacity of INT (in
which case, you can use BIGINT)... 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@discussions.microsoft.com> wrote in message
news:609C4EC9-10C7-43F6-BB0A-D930F90B8AE7@microsoft.com...
> What is the standard for primary key IDs as far as data type.  Integer vs
> Numeric?
>
> Thanks

Relevant Pages

  • Re: Freeing Algorithms
    ... On the other hand, int is simple, efficient, and handles very ... The data type int falls somewhere before the requirement of the user. ... To paraphrase the requirement (since requirements cannot be accurately expressed in English (or a programming language for the Mr. TDD!)), a data type that extended between negative and positive infinity is required to express the arrow of time. ... Assuming Java provided a data type that permitted an extension to infinity, then it would certainly make int look like hitherto "overkill". ...
    (comp.lang.java.programmer)
  • Re: User Input issue
    ... now we know that the int data type uses 4 bytes of memory. ... You wrote a moment ago that the programmer does not ... covered strings yet (I'm a college freshman in a Programming I/Novice ...
    (comp.lang.c)
  • RE: time_t size and year 2038 wrap
    ... > as long int. ... > redhat site for date 2038 and found very little current ... To bullet proof your code, you could declare a data type, ... or manipulations on your special versions of date-time. ...
    (RedHat)
  • Re: Working with Cash and uses of Typedef
    ... Which data type should I use instead? ... If you're tracking tenths of pennies, that same 16 bit int ... Abstraction is a powerful tool, and when done properly can make life ...
    (comp.lang.c)
  • User Input issue
    ... now we know that the int data type uses 4 bytes of memory. ... either a C-style string or C++ string and then use the stdlib header ... covered strings yet (I'm a college freshman in a Programming I/Novice ...
    (comp.lang.c)