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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-16 : 10:03:19
|
| Tracy writes "I always use application to generate a unique ID as a primary key instead of using identity column in a table. For example, a User Table always has primary key prefixed with USR i.e. USR001, I use a table to store the prefix for each table and has a column of 'AutoNumber' which is updated frequently when a row inserted. Is it a bad approach to implement this kind of practise? I use this approach since i felt that the Identity column as primary key is very difficult to recognise when we use it in application. What is the recommended practise?" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-16 : 10:07:37
|
| Rob preaches what you are doing rite now. he has written a article on it. Read Articles comments too. you will get a fair opinion.follow this http://www.sqlteam.com/item.asp?ItemID=2599 -------------------------------------------------------------- |
 |
|
|
|
|
|
Primary Key in a Table