You set the start number for an identity column in the column design so its not really appropriate for your problem. Just make sure you handle the error if two users try to insert the same id at the same time.
MCSD, MCPD, MCTS
Marked as answer by programercek on Sep 28, 2010 01:02 PM
frez
Contributor
5418 Points
913 Posts
Re: How to increase the number + 1
Sep 28, 2010 12:58 PM|LINK
You set the start number for an identity column in the column design so its not really appropriate for your problem. Just make sure you handle the error if two users try to insert the same id at the same time.