Sequence

Question

Sequence

Viewing 7 posts - 16 through 21 (of 21 total)

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

Drew Copenhaver Right there with Babe Points: 763 More actions · Answer 1

OCTom (10/16/2013)
Since I'm not using 2012, yet, I didn't know about SEQUENCE. So, I looked it up and found a nice Technet article by Denny Cherry.
He not only explains what it is but also why you might use it.
http://technet.microsoft.com/en-us/magazine/hh407114.aspx

Yeah, I noticed there weren't really use cases on MSDN or the cited article. It wouldn't have been introduced if it wasn't useful, but I'm having trouble coming up with a case where I would use it. Then again, we've only had 2012 here for about a week and a half. Thanks for the article with use cases!

Luis Cazares SSC Guru Points: 183698 More actions · Answer 2

Drew Copenhaver (10/16/2013)
OCTom (10/16/2013)
Since I'm not using 2012, yet, I didn't know about SEQUENCE. So, I looked it up and found a nice Technet article by Denny Cherry.
He not only explains what it is but also why you might use it.
http://technet.microsoft.com/en-us/magazine/hh407114.aspx
Yeah, I noticed there weren't really use cases on MSDN or the cited article. It wouldn't have been introduced if it wasn't useful, but I'm having trouble coming up with a case where I would use it. Then again, we've only had 2012 here for about a week and a half. Thanks for the article with use cases!

Maybe it's included because people coming from Oracle asked for it.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Drew Copenhaver Right there with Babe Points: 763 More actions · Answer 3

Luis Cazares (10/16/2013)
Drew Copenhaver (10/16/2013)
OCTom (10/16/2013)
Since I'm not using 2012, yet, I didn't know about SEQUENCE. So, I looked it up and found a nice Technet article by Denny Cherry.
He not only explains what it is but also why you might use it.
http://technet.microsoft.com/en-us/magazine/hh407114.aspx
Yeah, I noticed there weren't really use cases on MSDN or the cited article. It wouldn't have been introduced if it wasn't useful, but I'm having trouble coming up with a case where I would use it. Then again, we've only had 2012 here for about a week and a half. Thanks for the article with use cases!
Maybe it's included because people coming from Oracle asked for it.

Oh yeah? I'm really not familiar with Oracle. What kind of real-world stuff would you use this for? Either in SQL or Oracle.

Luis Cazares SSC Guru Points: 183698 More actions · Answer 4

As far as I know, because I'm not that familiar with oracle either, Oracle doesn't have an Identity functionality as SQL Server has. That's why they use sequence.

Looking for information to confirm this, I found that they included something similar in Oracle until 12c, so before that, sequence was the way to go.

Reference: http://www.oracle-base.com/articles/12c/identity-columns-in-oracle-12cr1.php

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Drew Copenhaver Right there with Babe Points: 763 More actions · Answer 5

Oh, okay, that makes a lot of sense then. Thank you! It's more the 'across multiple tables or outside of tables' thing I'm having trouble finding use cases for.

free_mascot One Orange Chip Points: 27169 More actions · Answer 6

Good easy one.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

jfgoude SSCrazy Points: 2586 More actions · Answer 7

I am on a really good sequence 🙂

five good answers on a range !

🙂