Sequences I

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by sknox » Sequences I

37 posts, Page 4 of 4

«««1 2 3 4

Sequences I

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Wednesday, April 18, 2012 1:44 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:38 PM
Points: 7,077, Visits: 7,116

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1286021

codebyo

Posted Wednesday, April 18, 2012 9:06 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:30 AM
Points: 861, Visits: 1,436

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. Smile

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2

Post #1286154

andy mack

Posted Thursday, April 19, 2012 9:30 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 9:52 AM
Points: 101, Visits: 64

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

Britt Cluff

Posted Monday, April 23, 2012 8:19 PM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,558, Visits: 247

Good question on a new feature. Thanks for submitting.

http://brittcluff.blogspot.com/

Post #1288622

Hardy21

Posted Monday, May 21, 2012 2:21 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877, Visits: 1,158

Britt Cluff (4/23/2012)

Good question on a new feature. Thanks for submitting.

+1

Thanks

Post #1303216

demonfox

Posted Friday, August 03, 2012 5:46 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:46 PM
Points: 1,074, Visits: 1,076

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 Ermm

Post #1339748

Dineshbabu

Posted Wednesday, January 09, 2013 6:30 AM

Right there with Babe

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746, Visits: 435

Before answering referred BOL many times, so i got it correct..

--
Dineshbabu
Desire to learn new things..

Post #1404734

« Prev Topic | Next Topic »

37 posts, Page 4 of 4

«««1 2 3 4

Permissions