How to insert value to auto increment field ?

• thang_ngo_2002

  SSCrazy

  Points: 2187

  More actions

  November 13, 2011 at 10:26 am

  #259854

  I have an example table A with these fields:

  ID: int, auto increment

  Content: varchar

  This table has so many records so I delete old records frequency, it has records from ID 100,000,000 to 101,000,000. Records ID under 100,000,000 were deleted.

  Now for special reason, i want to insert record with ID 90,000,000 back to this table

  So how can I do when ID is auto increment field ? (I don't want to remove auto increment of this field, even temporary)

  Thanks

• Paul White

  SSC Guru

  Points: 150467

  More actions

  November 13, 2011 at 10:45 am

  #1406848

  See this page in SQL Server Books Online:

  SET IDENTITY_INSERT (Transact-SQL)

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• thang_ngo_2002

  SSCrazy

  Points: 2187

  More actions

  November 13, 2011 at 11:11 am

  #1406852

  OK, I see, thanks very much.