Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting auto-incremented fields manually

Status
Not open for further replies.

sgk17

Technical User
Nov 8, 2002
68
US
I'm working with a table that has an auto-incrementing primary key field. Initially, I want to be able to programmatically set the primary key field and then when I'm done initializing the table and the regular work begins the primary key field should start incrementing beginning at the largest value entered + 1. Is this possible? Is there any way to manually enter data into an auto-incrementing field? Thanks.
 
see SET IDENTITY_INSERT in BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top