IDENTITY in a multiple-column index

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)

IDENTITY in a multiple-column index

Author

Topic

SamLowry
Starting Member

4 Posts

Posted - 2006-03-25 : 10:11:50

Hi,

Is it possible to have IDENTITY as a secondary column in a multiple-column index.
I need autogenerated unique values to be unique not on a table scope but on the scope of set of rows with same value of first column of the index.

If this is not possible with MS SQL, how can I get to it?

Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-03-25 : 12:01:49

http://weblogs.sqlteam.com/mladenp/archive/2005/08/01/7421.aspx
point 1
- groups of data

is that what you're looking for?

this is not possible with autogeneration

Go with the flow & have fun! Else fight the flow

SamLowry
Starting Member

4 Posts

Posted - 2006-03-25 : 12:39:11

quote:
Originally posted by spirit1

http://weblogs.sqlteam.com/mladenp/archive/2005/08/01/7421.aspx
point 1
- groups of data

is that what you're looking for?

this is not possible with autogeneration

Go with the flow & have fun! Else fight the flow

Thank you spirit1,
I got the idea although I'm not very happy with it!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources