SQL server identity column values start at 0 instead of 1

by

From DBCC CHECKIDENT

DBCC CHECKIDENT ( table_name, RESEED, new_reseed_value )

If no rows have been inserted to the
table since it was created, or all
rows have been removed by using the
TRUNCATE TABLE statement, the first
row inserted after you run DBCC
CHECKIDENT uses new_reseed_value as
the identity. Otherwise, the next row
inserted uses new_reseed_value + the
current increment value.

So, this is expected for an empty or truncated table.

More Related Contents:

  1. SQL Server 2005 ROW_NUMBER() without ORDER BY
  2. Add a column with a default value to an existing table in SQL Server
  3. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  4. How can I do an UPDATE statement with JOIN in SQL Server?
  5. The multi-part identifier could not be bound
  6. Fastest way to update 120 Million records
  7. Is it possible to select sql server data using column ordinal position
  8. How to find current transaction level?
  9. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  10. How to insert multiple records and get the identity value?
  11. How to Replace Multiple Characters in SQL?
  12. How can a LEFT OUTER JOIN return more records than exist in the left table?
  13. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  14. Dynamic SQL to generate column names?
  15. SQL comma-separated row with Group By clause
  16. Column name or number of supplied values does not match table definition
  17. SQL Server PIVOT perhaps?
  18. How to find consecutive rows based on the value of a column?
  19. Should I use SQL_Variant data type?
  20. SQL server select distinct rows using most recent value only
  21. Script to save varbinary data to disk
  22. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  23. How to select date without time in SQL
  24. What is the internal representation of datetime in sql server?
  25. Eliminate and reduce overlapping date ranges
  26. Cumulative Total in MS Sql server [duplicate]
  27. SQL query to group by day
  28. Export table data from one SQL Server to another
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. SQL, How to Concatenate results?

Leave a Comment