Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
how to auto reset identity value
parthiban karnan
Apr 23 2013 7:15 AM
879
Reply
I HAVE CREATED IDENTITY VALUE FOR COLUMN ID IN TABLE..
IDENTITY(1,1)..
IF I DELETE RECORD ID
11
..AND NEW RECORD ..ID IS TAKEN
13
NOT
12
..
I USE TO RUN SQL QUERY
DBCC IDENTCHECK('TABLENAME',RESEED, 11)
EVERY TIME..
HOW TO AUTOMATICALLY RESEED COLUMN VLAUE..
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Update not reflect at the time of updation in sql database.
Generate Random Numbers with Predefined Sum