Reseting the seed of column identity in sql sever using stored procedures


/ Published in: SQL
Save to your folder(s)

using this code in a stored procedure you can reset the seed of the identity column in sql server database


Copy this code and paste it in your HTML
  1. @seed INT
  2. AS
  3. DBCC CHECKIDENT (Lease,RESEED,@seed)
  4. RETURN

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.