Sequences I

Question

Sequences I

Viewing 6 posts - 31 through 36 (of 36 total)

You must be logged in to reply to this topic. Login to reply

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 1

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/MCSE/MCSA

andy mack Old Hand Points: 324 More actions · Answer 2

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.

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 3

Good question on a new feature. Thanks for submitting.

http://brittcluff.blogspot.com/

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 4

Britt Cluff (4/23/2012)
Good question on a new feature. Thanks for submitting.

+1

Thanks

demonfox SSCertifiable Points: 6289 More actions · Answer 5

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:

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 6

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

--
Dineshbabu
Desire to learn new things..