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 |
|
gk_sql
Starting Member
9 Posts |
 Posted - 2006-07-14 : 15:06:12
|
| Hi, How can we use two identity column (with identity property) in table ? GKgk |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-14 : 16:35:18
|
quote:
Originally posted by gk_sql
Hi, How can we use two identity column (with identity property) in table ? GKgk
You can only have one identity column in a table.CODO ERGO SUM |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-07-14 : 16:50:48
|
| I am really curious if anyone can come up with a reason why you'd ever need more than one ....- Jeff |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-07-14 : 16:53:56
|
| Why on earth would you want to do that? |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-14 : 17:32:08
|
| I, on the other hand, do not want to know the reason.I'm sure it will make my head hurt.CODO ERGO SUM |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-07-14 : 17:58:56
|
| ROTFLA Schizophrenic table perhaps? |
|
|
|
|
|
|
Two identity cols in table