<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by sknox
»
Sequences I
37 posts, Page 2 of 4
««
1
2
3
4
»
»»
Sequences I
Rate Topic
Display Mode
Topic Options
Author
Message
DugyC
DugyC
Posted Tuesday, April 17, 2012 2:58 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:25 AM
Points: 1,165,
Visits: 731
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
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, April 17, 2012 3:01 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378,
Visits: 6,473
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
Nic-306421
Nic-306421
Posted Tuesday, April 17, 2012 4:39 AM
Valued Member
Group: General Forum Members
Last Login: Monday, May 20, 2013 7:31 AM
Points: 58,
Visits: 540
A great questions, got me thinking so well worth it.
Thank you.
Post #1284815
Thomas Abraham
Thomas Abraham
Posted Tuesday, April 17, 2012 5:32 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 4:58 AM
Points: 1,152,
Visits: 1,457
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.
Post #1284832
jfogel
jfogel
Posted Tuesday, April 17, 2012 7:11 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 6:37 PM
Points: 309,
Visits: 685
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
SQLDCH
SQLDCH
Posted Tuesday, April 17, 2012 8:06 AM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:19 AM
Points: 891,
Visits: 2,266
Thanks, learned something new.
----------------------------------------------------------------------------
My LinkedIn profile -
LinkedIn
Sacramento SQL Server users group -
http://sac.sqlpass.org
My blog -
http://www.expressnetsolutions.com/sqldch
Follow me on Twitter -
@SQLDCH
----------------------------------------------------------------------------
Yeah, well...The Dude abides.
Post #1284941
Cliff Jones
Cliff Jones
Posted Tuesday, April 17, 2012 8:07 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 3,400,
Visits: 3,411
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
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Posted Tuesday, April 17, 2012 8:56 AM
Ten 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
EL Jerry
EL Jerry
Posted Tuesday, April 17, 2012 9:15 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748,
Visits: 928
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
KWymore
KWymore
Posted Tuesday, April 17, 2012 9:39 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 10:59 AM
Points: 2,579,
Visits: 1,537
Thanks for the 2012 question. Keep 'em coming.
Post #1285043
« Prev Topic
|
Next Topic »
37 posts, Page 2 of 4
««
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
