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
 assigning automatic values to primary keys

Author  Topic 

ericaq_74
Starting Member

2 Posts

Posted - 2007-08-10 : 12:08:58
what other method can you use to generate primary keys automatically. My boss disagrees with me using identity for the primary keys. He says it is not professional. I am working on SQL Server 2005 platform. Can anybody advice me?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-08-10 : 12:15:55
There is no other 'automatic' way other than setting it as an IDENTITY column. Anything else has to be manual computation.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-08-10 : 12:20:56
quote:
Originally posted by ericaq_74
... My boss disagrees with me using identity for the primary keys. He says it is not professional...Can anybody advice me?


Your boss is a dumbass. Pay no attention to anything he says.




CODO ERGO SUM
Go to Top of Page

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-10 : 12:26:10
YES HE IS A BIG BIG DUMB ASS.

TELL HIM TO CODE HIMSELF.

I HAVE DEALT WITH SUCH JERKS IN THE PAST


Ashley Rhodes
Go to Top of Page
   

- Advertisement -