SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / What is equlient to Oracle "Create Sequence" in SQL Server 2005? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 18:25:14 GMT20RE: What is equlient to Oracle "Create Sequence" in SQL Server 2005?http://www.sqlservercentral.com/Forums/Topic481007-338-1.aspxOpen Books Online, copy and paste the address into the URL field. Should get you there.Mon, 07 Apr 2008 13:43:55 GMTGSquaredRE: What is equlient to Oracle "Create Sequence" in SQL Server 2005?http://www.sqlservercentral.com/Forums/Topic481007-338-1.aspxThanks for the reply.But the link you provided is not opening the page, you asked.Could you please check the link and send me again if any error on it.Thanks again!Mon, 07 Apr 2008 12:38:54 GMTmshah23RE: What is equlient to Oracle "Create Sequence" in SQL Server 2005?http://www.sqlservercentral.com/Forums/Topic481007-338-1.aspxIf I'm reading "Create Sequence" correctly, I think you'll find Identity does what you need.Books Online has data on it at:[url]ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/8429134f-c821-4033-a07c-f782a48d501c.htm[/url]Mon, 07 Apr 2008 12:00:48 GMTGSquaredWhat is equlient to Oracle "Create Sequence" in SQL Server 2005?http://www.sqlservercentral.com/Forums/Topic481007-338-1.aspxWhat is equlient to Oracle "Create Sequence" in SQL Server 2005?Mon, 07 Apr 2008 11:21:33 GMTmshah23