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

Sequences III Expand / Collapse
Author
Message
Posted Tuesday, May 1, 2012 11:33 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
Nice question. A bit easy, as I know practically the syntax for Sequence by heart after the first two questions



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1293616
Posted Friday, May 4, 2012 7:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:15 AM
Points: 1,432, Visits: 1,059
This series of questions has given me a good understanding of sequences. I hope I remember this if/when my company ever upgrades to SQL Server 2012. Thanks for the intro to new features!
Post #1295237
Posted Tuesday, May 8, 2012 2:06 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 @ 2:09 PM
Points: 977, Visits: 940
thanks, easy one

Iulian
Post #1296277
Posted Thursday, May 17, 2012 8:02 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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

http://brittcluff.blogspot.com/
Post #1302233
Posted Wednesday, January 9, 2013 5:50 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
Still i didn't get a chance to work in 2012, But keeping property of IDENTITY and minimum value of INT in mind I answered and luckily i got it correct. I don't know what value will be returned CYCLE is mentioned.

Thanks for posting 2012 feature..


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

Add to briefcase «««123

Permissions Expand / Collapse