Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Reset @@identity column - Which one is better
Suthish Nair
Oct 15 2010 3:02 PM
2.5k
Reply
DBCC CHECKIDENT('TableName', RESEED, 0)
truncate table dbo.TableName
which one is better to reset @@identity column. Lets have a discussion.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Sending automatic alert email via sql server
1. Calculation of Delay in a work using shif timing