Really Simple Question!!

• erdem1973

  SSCommitted

  Points: 1843

  More actions

  June 9, 2006 at 6:43 am

  #94045

  Hello,

  I will ask a very simple question..But My brain is stopped!!! So I want to ask this question to you:

  I have a table that consists just one column.And there are approx. 300 records in the table.Now I want to add another integer column named RouteID..This RouteID column will consists sequential integer numbers.

   

  How can I do this?

  PLEASE HELP...

  Regards

• sree-226516

  SSCrazy

  Points: 2590

  More actions

  June 9, 2006 at 6:59 am

  #642775

   

  I donno if this is what you are looking for.

  ALTER TABLE Table_name ADD RouteID  INT IDENTITY.

   

  Thanks,

  SR

  Thanks,
  SR

• erdem1973

  SSCommitted

  Points: 1843

  More actions

  June 9, 2006 at 7:25 am

  #642781

  Thank you very much..

  This is the solution!!