April 24, 2012 at 11:32 am
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.
April 24, 2012 at 11:55 am
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.
April 24, 2012 at 1:33 pm
Nice fun question. And really nice to see that MS has picked defaults that make sense for this new feature.
Tom
April 25, 2012 at 4:32 am
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?
April 25, 2012 at 6:43 am
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
April 25, 2012 at 9:39 am
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!
April 25, 2012 at 10:15 am
Nice 2012 question. Thanks!
April 26, 2012 at 10:06 am
straight forward question - thanks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 7, 2012 at 2:43 am
thanks for the question, new feature questions are always nice
August 3, 2012 at 6:58 am
Nice question!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 9, 2013 at 6:10 am
dawryn (4/24/2012)
tommyh (4/23/2012)
Startvalue will be MinValue (since its not given).Check reference again. Start value is different whether sequence is ascending or descending.
without properly understanding difference between asc and desc. I answered wrongly..
--
Dineshbabu
Desire to learn new things..
Viewing 11 posts - 31 through 40 (of 40 total)
You must be logged in to reply to this topic. Login to reply