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)
 Unique ID with Letters

Author  Topic 

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2001-10-12 : 19:53:05
Hi there,

Just thought Id post this to get an idea of best practise. I have a client that wants their primary key for a specific table to have the following format:

WWW-NNNNNNNN

where N= Unique id generated by 1.

Any thoughts on this as a primary key?

   

- Advertisement -