Update or Set the auto increment column in Sql Server

Question

0.00/5 (No votes)

See more:

hello friends,

i have online shopping website. i have deleted some product from database in Product table. in that table i have one field name ID which is auto increment. now i want to upload a new product in my Product table. after that want to update the ID field. i want to set the ID of that record which i previously deleted....
IS that posible to Set that ID???

Replay

Thank You....

Posted 12-Apr-12 4:49am

Yatin_Chauhan

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

abhijeetgupta1988 · Answer 1 · 2012-04-12T04:54:00

Solution 1

No,You can't.
The only way I know by truncating your table then by inserting all records again!

Posted 12-Apr-12 4:54am

abhijeetgupta1988

Comments

Yatin_Chauhan 12-Apr-12 11:26am

I HAVE updated that ID using update query. also update all the table related to product. and they all are updated... but the problem is that to display in front side. it gives error..
thx u for replay abhijeet

Yatin_Chauhan 12-Apr-12 11:38am

i got the error like that
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

abhijeetgupta1988 13-Apr-12 12:47pm

then I guess you need to check with your stored proc/query,and few exception handling blocks!