If you can make it a computed column, that would do it. CREATE TABLE YourTable (PK INT NOT NULL IDENTITY(1,1) PRIMARY KEY, boxnumber AS 50000+PK);
For an existing table, add it as a new column using alter table and if you are happy drop the existing column.
There is an article on SQLTeam blog about generating custom sequences in T-SQL; I have not read through it entirely, but it might be useful to you http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server
Trigger to increment a column
Posted - 01/25/2013 : 11:52:57
