what if maximum value is reached [int datatype]

• mowkz

  SSC Veteran

  Points: 218

  More actions

  September 28, 2009 at 4:46 am

  #214863

  Hi All,

  I have a table with a column of type int and has the following properties:

  identity = yes; identity speed = 1; identity increment = 1.

  I'm just wondering what would be the behavior of the table if

  the maximum value is reached (4 000 000 000 +)?

  Will the value of this column reset to 0?

  your response is highly appreciated.

  thank you very much!

• Mark Cowne

  One Orange Chip

  Points: 26967

  More actions

  September 28, 2009 at 5:08 am

  #1058946

  Try it yourself

  CREATE TABLE Test(i INT IDENTITY(2147483646,1))

  INSERT INTO Test DEFAULT VALUES

  SELECT * FROM Test

  INSERT INTO Test DEFAULT VALUES

  SELECT * FROM Test

  INSERT INTO Test DEFAULT VALUES

  SELECT * FROM Test

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537