Data Type

What is the standard for primary key IDs as far as data type. Integer vs
Numeric?
Thanks
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
|||>> What is the standard for primary key IDs as far as data type. Integer vs[vbcol=seagreen]
There are no standards w.r.t data types for a key.
Anith
|||"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?
What are you modelling?
Say it's cars... you'd want VIN. If it's books, ISBN.
etc.

> Thanks