Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Simple Primary Key Question???

Author  Topic 

jamiegirl764
Starting Member

30 Posts

Posted - 2001-10-26 : 14:13:28
This is probably a simple question to all the professionals out there, but I just need a second opinion.

I have a table where some of the primary keys need to begin with zero so I set the datatype to VARCHAR. Is it logical or correct to have a primary key of VARCHAR datatype??? Or would it be more logical to insert an IDENTITY column as a primary key rather the the column of VARCHAR datatype???

A second opinion would be very appreciated! Thanks in advance!!!

Jay

   

- Advertisement -