CREATE TABLE #tmp (id int identity(1,1), label varchar(50))
INSERT INTO #tmp (label) VALUES ('one'), ('two'), ('three')
DBCC CHECKIDENT (#tmp, RESEED, 999)
INSERT INTO #tmp (label) Values ('one thousand')
SELECT * FROM #tmp
Open in new window
Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!