Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»

Sequences II Expand / Collapse
Author
Message
Posted Tuesday, April 24, 2012 11:32 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
Well maybe it was not so easy -- currently only 25 percent of correct answers. That's the lowest one I have seen in a long time.
Post #1289233
Posted Tuesday, April 24, 2012 11:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:42 PM
Points: 1,309, Visits: 1,685
Revenant (4/24/2012)
Well maybe it was not so easy -- currently only 25 percent of correct answers. That's the lowest one I have seen in a long time.


Yes, it looks like most people are thinking that sequence defaults to starting at the lowest value, and therefore runs out. That was the first "gotcha" I thought of, and I was pleasantly surprised that Microsoft had thought of it too.
Post #1289248
Posted Tuesday, April 24, 2012 1:33 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 3:34 PM
Points: 8,737, Visits: 9,281
Nice fun question. And really nice to see that MS has picked defaults that make sense for this new feature.

Tom
Post #1289321
Posted Wednesday, April 25, 2012 4:32 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
I'm obviously missing something here.

"SELECT NEXT VALUE FOR SSC_ROCKS;" is used twice in the question, so why aren't two numbers returned?
Post #1289713
Posted Wednesday, April 25, 2012 6:43 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 3:34 PM
Points: 8,737, Visits: 9,281
marlon.seton (4/25/2012)
I'm obviously missing something here.

"SELECT NEXT VALUE FOR SSC_ROCKS;" is used twice in the question, so why aren't two numbers returned?

Two numbers are returned. But the answer is ony one of these two values, the scond of the two, because
the question asks what value is returned by the second select statement, not what are all values returned by both select statements.


Tom
Post #1289798
Posted Wednesday, April 25, 2012 9:39 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 8:03 AM
Points: 825, Visits: 319
L' Eomot Inversé (4/25/2012)
marlon.seton (4/25/2012)
I'm obviously missing something here.

"SELECT NEXT VALUE FOR SSC_ROCKS;" is used twice in the question, so why aren't two numbers returned?

Two numbers are returned. But the answer is ony one of these two values, the scond of the two, because
the question asks what value is returned by the second select statement, not what are all values returned by both select statements.


Obviously reading the question helps!
Post #1290031
Posted Wednesday, April 25, 2012 10:15 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:23 AM
Points: 3,299, Visits: 1,978
Nice 2012 question. Thanks!
Post #1290085
Posted Thursday, April 26, 2012 10:06 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 1:51 PM
Points: 21,644, Visits: 15,317
straight forward question - thanks



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1290901
Posted Monday, May 7, 2012 2:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 5:25 AM
Points: 939, Visits: 885
thanks for the question, new feature questions are always nice
Post #1295835
Posted Friday, August 3, 2012 6:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:45 AM
Points: 2,531, Visits: 536
Nice question!

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
Post #1339793
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse