<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 Nakul Vachhrajani
»
Fun with IDENTITY - Part I
19 posts, Page 1 of 2
1
2
»»
Fun with IDENTITY - Part I
Rate Topic
Display Mode
Topic Options
Author
Message
Nakul Vachhrajani
Nakul Vachhrajani
Posted Tuesday, September 28, 2010 8:35 PM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 9:52 AM
Points: 1,277,
Visits: 1,608
Comments posted to this topic are about the item
Fun with IDENTITY - Part I
Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #994897
sknox
sknox
Posted Tuesday, September 28, 2010 8:37 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:22 AM
Points: 1,037,
Visits: 1,354
Good question. It would have been more difficult if there had been an option for 1-Boston;2-New Delhi
Post #994899
Dhruvesh Shah
Dhruvesh Shah
Posted Tuesday, September 28, 2010 9:37 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, July 25, 2012 9:04 PM
Points: 542,
Visits: 187
Agree. i thought that it's testing for identity column values. but still good question.
Post #994906
UMG Developer
UMG Developer
Posted Tuesday, September 28, 2010 10:23 PM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163,
Visits: 2,148
I agree, nice question, but it would have been even better with a fourth option: 1-Boston;2-New Delhi
Without that option it was really a test of transactions, not of IDENTITY. (Maybe that was the point to through people off the scent?)
Post #994910
Chris Houghton
Chris Houghton
Posted Wednesday, September 29, 2010 1:35 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 9:12 AM
Points: 557,
Visits: 1,356
Agreed, I was expecting it to be a trick question. A 2 New Delhi option would've made it less obvious. It is still good to be reminded that the identity column counter doesn't revert to the previous value when a transaction affecting it is rolled back.
Thanks
Post #994964
jts_2003
jts_2003
Posted Wednesday, September 29, 2010 1:43 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 12:18 PM
Points: 1,060,
Visits: 4,158
I was looking for the catch - nice that for once it wasn't a trick question!
Post #994969
DugyC
DugyC
Posted Wednesday, September 29, 2010 2:23 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 3:14 AM
Points: 1,160,
Visits: 726
Good question but, regardless of whether it was a "deception" or to "throw people off the scent", the lesson was lost in the absence of the fourth option for "1 Boston, 2 New Delhi".
Just seems like a trick was missed, I imagine a lot of people may have gone for this fourth option and when it was pointed out they were wrong they'd learn more because they were focus'ed on why they got it wrong.
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #994987
ziangij
ziangij
Posted Wednesday, September 29, 2010 2:38 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:53 AM
Points: 1,526,
Visits: 359
thanks... got to learn something new today.. .
Post #994991
NickBalaam
NickBalaam
Posted Wednesday, September 29, 2010 2:55 AM
Old Hand
Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:27 AM
Points: 342,
Visits: 788
Interesting to see in action that uncommitted transactions still affect the identity values. Nice.
Post #995002
cengland0
cengland0
Posted Wednesday, September 29, 2010 3:48 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354,
Visits: 1,299
jts_2003 (9/29/2010)
I was looking for the catch - nice that for once it wasn't a trick question!
Same here. I'm always looking for typos or some other trick.
Nice to see a straight-forward question for a change.
Post #995025
« Prev Topic
|
Next Topic »
19 posts, Page 1 of 2
1
2
»»
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.
