Post reply

AutoNumber

  • September 20, 2006 at 2:46 am

    #114580

    How is possible to have an autonumber field type in Sql Server;

  • September 20, 2006 at 9:43 am

    #661542

    Do you mean autoincrement ? If so, here it is:

    create table my_table

    (

    field_with_autonumber int identity(1,1)

    other_fields int

    )

     

  • September 26, 2006 at 1:50 pm

    #662571

    There is no autonumber field type but there are types of fields that can be given the Identity property that will automatically be incremented when a row is inserted.  See Books On Line "Creating and Modifying Identifier Columns".

    Steve

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply