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

Question

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

Books Online has data on it at:

- 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

mshah23 SSChasing Mays Points: 649 More actions · Answer 2

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!

GSquared SSC Guru Points: 260824 More actions · Answer 3

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