Numeric data type

[Vhost]

Should a numeric data type (SQL Server) ever be used as primary key/row identifier
instead of the int data type? I have inherited a DB with numeric data types
as primary keys. I think they should be changed to int or bigint.

[Craig Clearman]

>Should a numeric data type (SQL Server) ever be used as primary key/row identifier
>instead of the int data type? I have inherited a DB with numeric data types
>as primary keys. I think they should be changed to int or bigint.

That would depend on whether the database is for a product that might
have to be ported to other database management systems. If you know
that the application will always be using SQL Server, then there is no
real reason to use numeric. bigint can handle large enough tables.

Ciao, Craig