SQL SERVER(T-SQL)

• maheshkrishnas

  Ten Centuries

  Points: 1045

  More actions

  February 15, 2012 at 2:28 am

  #250751

  Hi all,

  Can we create Sequences in SQL Server? I know I used identity column instead of Sequences in SQL Server.

  When I went through some help documents it says

  1. Create schema

  2. Cretae a sequence

  But when I am trying to create a sequence

  CREATE

  SEQUENCE test.Seq_one AS int INCREMENT BY 1 ;

  Msg 343, Level 15, State 1, Line 2

  Unknown object type 'SEQUENCE' used in a CREATE, DROP, or ALTER statement.

  Please let me know if this does not exists in SQL 2008.

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  February 15, 2012 at 2:32 am

  #1447186

  SQL Server 2012 has Sequence.

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 15, 2012 at 5:26 am

  #1447277

  Paul White blogged about simulating sequences in SQL Server here.

  -- Gianluca Sartori