help me on setting auto number property for a column

• rammohan-372344

  Newbie

  Points: 5

  More actions

  October 4, 2006 at 3:35 am

  #192600

  hi,

  here i am trying to create a table in which i want give a property autonumber(i.e increments simultaneously for each new row) to a field.pls tell me the procedure for this in sql server2005

  i tried as,

  create table Table_Num

  num int primary key,

  voice int auto)

  but it is not working.pls tell me the syntax for setting auto number property for a particular prperty.

  thanx in advance,

  rammohan

• Ram Ram

  Ten Centuries

  Points: 1079

  More actions

  October 4, 2006 at 4:18 am

  #664047

  CREATE TABLE xyz

  (TABLE_NUM INT PRIMARY KEY,

  VOICE INT IDENTITY(1,1))

  -Ram