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 Tuesday, April 17, 2012 2:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Great question, and a nice feature to know about... not sure what I'd use it for mind.

At first thought it wasn't fair to ask a SQL 2012 question as its so new, but bit my lip and did a wee bit of research and the answer was there in a flash.

Relatively easy question come the end.

Cheers for the point.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1284751
Posted Tuesday, April 17, 2012 3:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 11:20 PM
Points: 13,252, Visits: 10,133
DugyC (4/17/2012)
At first thought it wasn't fair to ask a SQL 2012 question as its so new...


Hold on to yourself, because it's a SSIS 2012 question tomorrow




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 #1284754
Posted Tuesday, April 17, 2012 4:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 11, 2013 8:39 AM
Points: 58, Visits: 606
A great questions, got me thinking so well worth it.

Thank you.
Post #1284815
Posted Tuesday, April 17, 2012 5:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:31 AM
Points: 1,758, Visits: 2,135
Great question. Simple (with a single look at BOL), clear cut, a bit surprising, and on a new version. Thanks!

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1284832
Posted Tuesday, April 17, 2012 7:11 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 7, 2014 10:03 AM
Points: 368, Visits: 953
Got it right. It is nice to see the sequence feature is now in SQL Server. Mainly because developers had to use a sequence for Oracle and an identity column for SQL Server. At least now the code can move closer to being the same. Note I wrote closer.

Cheers
Post #1284902
Posted Tuesday, April 17, 2012 8:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 1,266, Visits: 2,730
Thanks, learned something new.

----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.
Post #1284941
Posted Tuesday, April 17, 2012 8:07 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:42 AM
Points: 3,869, Visits: 3,619
jfogel (4/17/2012)
Got it right. It is nice to see the sequence feature is now in SQL Server. Mainly because developers had to use a sequence for Oracle and an identity column for SQL Server. At least now the code can move closer to being the same. Note I wrote closer.

Yes, I agree. After all these years it is good to see it being implemented in SQL Server.
Post #1284942
Posted Tuesday, April 17, 2012 8:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks for the questions - +1 for learned something new today. cheers
Post #1284996
Posted Tuesday, April 17, 2012 9:15 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 3,786, Visits: 1,077
Good one. Good to know since I still don't have access to SQL Server 2012, but eventually will.

"El" Jerry.


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan
Post #1285016
Posted Tuesday, April 17, 2012 9:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:38 AM
Points: 3,254, Visits: 1,953
Thanks for the 2012 question. Keep 'em coming.
Post #1285043
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse