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 |
|
mastro78
Starting Member
9 Posts |
 Posted - 2008-11-05 : 13:55:59
|
| I'm creating a unique key in a new table. What I'd first like to do is create values in the unique key up to 1000. Example:1234....1000How would I go about doing this? Just a single field numbered from 1 to 1000. Thanks in advance. |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-11-05 : 14:23:05
|
| Why are you trying to create the key first? Couldn't this be better served by simply using an identity field, which will automatically seed the value and maintain uniqueness for you every time a new row is inserted? Edit - No offense intended but I have to ask - Your not funketekun in disguise, are you?? Just curious.....Terry |
 |
|
|
mastro78
Starting Member
9 Posts |
Posted - 2008-11-05 : 15:27:07
|
| I don't think I am. Just a ridiculous request I was told to come up with. No real reason behind it. Just wondering how to do it. |
|
|
|
|
|
|
Creating an index in a new table up to 1000 rows