Sequence

• joshy mathew

  Old Hand

  Points: 361

  More actions

  December 26, 2006 at 2:38 am

  #193555

  like sequence in oracle ,is there anything in sql server

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  December 26, 2006 at 9:25 am

  #679978

  CREATE TABLE #Demo (ID INT IDENTITY(1,1) NOT NULL)

  Insert into #Demo DEFAULT VALUES

  Insert into #Demo DEFAULT VALUES

  SELECT * FROM #Demo

  DROP TABLE #Demo

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 26, 2006 at 11:59 am

  #680001

  In sql server it is called IDENTITY...

  Check IDENTITY property/fuction....

  http://msdn2.microsoft.com/en-us/library/ms186775.aspx

  http://msdn2.microsoft.com/en-us/library/ms189838.aspx

  MohammedU
  Microsoft SQL Server MVP