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
 General SQL Server Forums
 New to SQL Server Programming
 Primary key

Author  Topic 

1821
Starting Member

18 Posts

Posted - 2008-04-14 : 17:24:19
Hi guys,

Is there a method in sql server 2005 to format the primary key so it can be alphanumberic?

Thanks.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-14 : 17:42:05
have a check constraint on a column and set it as a primary key.


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-04-14 : 17:48:27
Maybe you mean something like this?

http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server

Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page
   

- Advertisement -