What is equlient to Oracle "Create Sequence" in SQL Server 2005?

  • What is equlient to Oracle "Create Sequence" in SQL Server 2005?

  • If I'm reading "Create Sequence" correctly, I think you'll find Identity does what you need.

    Books Online has data on it at:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/8429134f-c821-4033-a07c-f782a48d501c.htm

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thanks 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!

  • Open Books Online, copy and paste the address into the URL field. Should get you there.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply