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 «««1234

Sequences I Expand / Collapse
Author
Message
Posted Wednesday, April 18, 2012 1:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 7,745, Visits: 9,493
Nice question. It's good to see some SQL 2012 stuff now and again.

I saw 0, 1, min(int), min(bigint) presented as options and decided I would have to find it in BoL; obviously if it had been a methematician who designed it I could forget about 1, but 0 was maybe possible (although far from optimal) and the thing would probably have type-flexibility (to cater for very long sequences when needed at the same time as allowing small numbers when vl sequences weren't needed) but that flexibility meant that the choice of which type would be default wasn't really constrained beyond the requirement for an integer type. So I had to find it in BoL instead of being able to guess the answer by applying common sense, which meant I did some useful reading again, which in turn meant that I thought it was a good question.


Tom
Post #1286021
Posted Wednesday, April 18, 2012 9:06 PM


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, September 23, 2014 1:04 PM
Points: 900, Visits: 1,490
I chose "1" as the default start value because I thought it would have the same behaviour of the IDENTITY property which defaults to "start with 1, increment 1". Seems I must study more closely this welcome new feature.

That means one less problem converting code to/from Oracle.


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #1286154
Posted Thursday, April 19, 2012 9:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 5:42 PM
Points: 107, Visits: 81
Nice question. Got it wrong and learned something in the process :) And sequences will be SQL 2012 exam questions so this is a great help.
Post #1286848
Posted Monday, April 23, 2012 8:19 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good question on a new feature. Thanks for submitting.

http://brittcluff.blogspot.com/
Post #1288622
Posted Monday, May 21, 2012 2:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:27 AM
Points: 1,130, Visits: 1,390
Britt Cluff (4/23/2012)
Good question on a new feature. Thanks for submitting.
+1


Thanks
Post #1303216
Posted Friday, August 3, 2012 5:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
I don't have 2012 yet , I went through msdn
http://msdn.microsoft.com/en-us/library/ff878091.aspx
I thought the answer would be min(bigint)+1 ; and that wasn't listed ; didn't understand the defaults ..
guess need to dig out more..


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1339748
Posted Wednesday, January 9, 2013 6:30 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: Monday, August 4, 2014 5:38 AM
Points: 945, Visits: 558
Before answering referred BOL many times, so i got it correct..

--
Dineshbabu
Desire to learn new things..
Post #1404734
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse