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 |
|
junior6202
Starting Member
45 Posts |
 Posted - 2014-10-16 : 14:37:08
|
| Hi All,I have a column that is not set to auto increment "IDX and Im inserting 800 part numbers but i want the IDX column to start at IDX 400 and increment 1 time per part number that is inserted. how can i accomplished that task.EXAMPLE:IDX PART#400 abcde401 fghi402 jklm. .etc. and so forth until the last part# will have IDX 1200... |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-10-16 : 15:50:22
|
http://stackoverflow.com/questions/1049210/adding-an-identity-to-an-existing-column
No amount of belief makes something a fact. -James Randi |
 |
|
|
|
|
|
increment column