How do I auto increment a field that is not the identity
I have a field in a table that I would like to increment by 1 everytime a new record is added. Preferably this would be on the table but I could include it in the stored procedure. Also, I would like to start with the number 4,000 and increment from there. Any ideas?