<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by sknox
»
Sequences II
41 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Sequences II
Rate Topic
Display Mode
Topic Options
Author
Message
Thomas Abraham
Thomas Abraham
Posted Tuesday, April 24, 2012 5:29 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 1,150,
Visits: 1,455
Excellent question. On a new feature, minimum code to make your point, clear cut answer, and several issues demonstrated at once. Bravo! (and Thanks!)
I think if you give it some thought, this feature behaves as you would design it. The defaults seem the way I would hope they would - for a pleasant change.
Please don't go. The drones need you. They look up to you.
Post #1288807
bitbucket-25253
bitbucket-25253
Posted Tuesday, April 24, 2012 5:30 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 5,102,
Visits: 20,205
I am some what confused and perplexed for when I run
(in Denalli CTP3)
SELECT name, start_value FROM sys.sequences;
the return values are:
name start_value
SSC_ROCKS 2147483647
and that start value is a POSITIVE VALUE.
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #1288809
Thomas Abraham
Thomas Abraham
Posted Tuesday, April 24, 2012 5:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 1,150,
Visits: 1,455
bitbucket-25253 (4/24/2012)
I am some what confused and perplexed for when I run
(in Denalli CTP3)
SELECT name, start_value FROM sys.sequences;
the return values are:
name start_value
SSC_ROCKS 2147483647
and that start value is a POSITIVE VALUE.
MAX for INT is 214748647, which it uses as start value because INCREMENT BY -1 indicates the sequence should be DESCENDING.
Please don't go. The drones need you. They look up to you.
Post #1288813
Toreador
Toreador
Posted Tuesday, April 24, 2012 5:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
Thomas Abraham (4/24/2012)
this feature behaves as you would design it.
Which is the reason I guessed wrong
Post #1288814
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, April 24, 2012 5:36 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:51 AM
Points: 9,373,
Visits: 6,470
sqlmunkee (4/24/2012)
So, the key bit here is that SQL will *decide* whether the sequence is ascending or descending based on the INCREMENT BY argument.
That only seems logical to me.
If the INCREMENT BY is negative, the sequence will automatically be a descending one, as you will always "take a step back".
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1288815
Thomas Abraham
Thomas Abraham
Posted Tuesday, April 24, 2012 5:38 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 1,150,
Visits: 1,455
Toreador (4/24/2012)
Thomas Abraham (4/24/2012)
this feature behaves as you would design it.
Which is the reason I guessed wrong
Ah yes, a SQL Server veteran. Burned by experience, conditioned to expect the unexpected.
Please don't go. The drones need you. They look up to you.
Post #1288816
jalvarocrespo
jalvarocrespo
Posted Tuesday, April 24, 2012 5:45 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:02 PM
Points: 116,
Visits: 76
damn it! MISTAKE with the cycle/no cycle argument not related with the start value!
I didn't know that the start value for the sequence is the maximum for a ascending sequence. Let's learning.
Post #1288819
jalvarocrespo
jalvarocrespo
Posted Tuesday, April 24, 2012 5:46 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:02 PM
Points: 116,
Visits: 76
damn it! MISTAKE with the cycle/no cycle argument not related with the start value!
I didn't know that the start value for the sequence is the maximum for a ascending sequence. Let's learning.
Post #1288820
bitbucket-25253
bitbucket-25253
Posted Tuesday, April 24, 2012 5:59 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 5,102,
Visits: 20,205
OK no longer confused or perplexed -
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #1288826
Thomas Abraham
Thomas Abraham
Posted Tuesday, April 24, 2012 6:08 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 1,150,
Visits: 1,455
Removed as issue is moot now that Ron is back in our space-time continuum.
Please don't go. The drones need you. They look up to you.
Post #1288834
« Prev Topic
|
Next Topic »
41 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
