Createding table simple question

• kirkdm01

  SSC-Addicted

  Points: 471

  More actions

  January 24, 2012 at 9:15 pm

  #391395

  When creating a table

  how do make the FieldID auto increment

  Create table(

  PostID int Primary auto increment

  ...

  )

• baabhu

  SSCertifiable

  Points: 6205

  More actions

  January 24, 2012 at 9:26 pm

  #1438076

  kirkdm01 (1/24/2012)

  ---

  When creating a table

  how do make the FieldID auto increment

  Create table(

  PostID int Primary auto increment

  ...

  )

  You are refereing to identity columns.

  Please google about identity columns.

  Create table RunningId (intSlno int Identity(1,1), Name varchar(100))

  This table will create will running number for intSlno column.

  -- Babu

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 24, 2012 at 10:47 pm

  #1438087

  http://www.simple-talk.com/sql/t-sql-programming/identity-columns/

• Paul White

  SSC Guru

  Points: 150468

  More actions

  January 24, 2012 at 10:56 pm

  #1438088

  CREATE TABLE dbo.Test

  (

  PostID integer IDENTITY PRIMARY KEY

  );

  See also these topics in Books Online (The SQL Server Help Library):

  Creating and Modifying Identifier Columns

  SCOPE_IDENTITY (Transact-SQL)

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi

• nhimabindhu

  Ten Centuries

  Points: 1242

  More actions

  January 24, 2012 at 10:59 pm

  #1438089

  create table tablename( column name int identity(1,1))

  identity refers auto increment first one refers from which number u has to start and the second one tells how much u need to increment

  for example

  create table tablename( column name int identity(100,10))

  it starts from 100 and increments by 10

  100

  110

  120 like this