Value Increment

• b_boy

  Newbie

  Points: 0

  More actions

  December 4, 2007 at 8:47 am

  #184524

  Hello

  I have created a table with serveral columns which have primary keys. What I want to do is to modify the table to so that whenever a record is inserted, the start value can be 5 and tne next 15 (increment value of 10)

  I have googles the net and can only see create sequence which doesnt seem work at all (thinking its an oracle thing)

  I need some help to learn how to create such T-SQL scripts from anyone who has done it.

• Jason Selburg

  Newbie

  Points: 0

  More actions

  December 4, 2007 at 8:52 am

  #756992

  Read up on IDENTITY Columns. you'll find your answer there.

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg

• b_boy

  Newbie

  Points: 0

  More actions

  December 4, 2007 at 11:08 am

  #757085

  Thanks, eventually found what i needed to do. I needed to create the table in this format:

  CREATE TABLE dbo.tablename( columnname1 smallint identity(7,2), columnname2 char(20) )