Home Forums Article Discussions Article Discussions by Author Discuss content posted by SQL Buzz Predict the outcome RE: Predict the outcome

  • July 15, 2010 at 9:51 am

    #1193592

    Chris Stewart-397033 (7/15/2010)

    Also in BOL under the CREATE TABLE entry is the following (partial) definition of IDENTITY (emphasis mine):

    IDENTITY

    Indicates that the new column is an identity column. When a new row is added to the table, the Database Engine provides a unique, incremental value for the column. ... The IDENTITY property can be assigned to tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0) columns.

    increment

    Is the incremental value added to the identity value of the previous row loaded.

    Since the engine creates a unique, incremental value, it must be a whole number value which fits in the bounds of the data type, and is other than zero.

    But what about that first inserted row, in this case with the value of -1?:-D

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers