Re: Auto increment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can do that with ALTER TABLE.


"QaiserMehmood" <qaiserme@xxxxxxxxxxx> wrote in message
news:52B86A44-EAB3-45CE-B2DA-77AB24F14A58@xxxxxxxxxxxxxxxx
Hi 2 all
Sir I set inv_no (auto increment) in my table sir when ever I zap this
table
and append it from backup table the field inv_no incremented sir how to
programmatically set the initial value of auto increment field and how set
the next step value
thanks


--
Qaiser Me


.

Relevant Pages

  • Re: [PHP] Pragmatically changing a "Record Number"
    ... I asked on a MySQL list about "Resetting a auto increment filed" so ... The ID key field of a record should not have any explicit meaning. ... Which is what I have figured out from the people on this list, I have decided to not play with the auto increment field, but the need I'm looking for hasn't changed, just the method. ... but they should have told you on the MySQL ...
    (php.general)
  • Re: DataSet auto increment problem
    ... Make sure that your update query is not trying to insert or update that ... The ID field is an auto increment field in SQL Server. ... "Constraint Exception was unhandled. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: auto-increment
    ... No, I don't need more than one identity column, I just wanted to have two ... Apparently an auto increment column should also be ... inserting auto increment values but currently have a data set that I need to ... auto increment field. ...
    (microsoft.public.sqlserver.programming)