<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 SQL Buzz
»
What will be the output of the following?
145 posts, Page 14 of 15
««
«
11
12
13
14
15
»»
What will be the output of the following?
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, June 29, 2010 12:51 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Once it's edited on the site, it will go out as the corrected version.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #944964
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, June 29, 2010 12:53 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Slight correction. It goes out edited in the next day's newsletter if it's not already scheduled. Sometimes we are scheduled out 2-3 days in a row.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #944966
dhirendra.singh
dhirendra.singh
Posted Wednesday, June 30, 2010 12:03 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 28, 2011 6:08 AM
Points: 2,
Visits: 19
in identity (-1,1) no first paramaeter shows number start from and second parameter shows number increment by mentioned. in that case "mainkey" will start from -1 and increased by 1. so Result will be
-1,0,1.
inf u will execute insert into MyTable default values
then mainkey will be -1
next time : insert into MyTable default values
mainkey =mainkey +1
so it will be 0
next time : insert into MyTable default values
mainkey =mainkey +1
so it will be 1
is it right ?
Post #945218
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, June 30, 2010 8:33 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
You are correct. The question was edited on the website to be (-1,-1). When you click through from the newsletter, that is what is shown.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #945532
sadowy
sadowy
Posted Wednesday, June 30, 2010 10:53 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 22, 2011 10:44 AM
Points: 2,
Visits: 23
I object.
The question presented in the email had:
mainkey int not null identity (-1,1)
but the code in the question and answer on the web site had:
mainkey int not null identity (-1,-1)
Post #945649
UMG Developer
UMG Developer
Posted Wednesday, June 30, 2010 10:57 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 2,163,
Visits: 2,151
Sadowy,
I think it is very common for the questions/answers to be corrected/edited between when they are email and when you may get to the web site. Being on the west coast of the US corrections are normally made before I get up and attempt the question.
Given that I don't pay much attention to the question in the email, I always read and answer what is on the web site.
Post #945652
JF1081
JF1081
Posted Wednesday, June 30, 2010 11:16 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:13 AM
Points: 436,
Visits: 322
sadowy (6/30/2010)
I object.
The question presented in the email had:
mainkey int not null identity (-1,1)
but the code in the question and answer on the web site had:
mainkey int not null identity (-1,-1)
EDIT: Removing grumpy comment that I added. Sorry, it has been a tough day.
The reason the email and question are different is explained in the 13 previous pages. You probably do not have to look much past page 2.
Post #945668
badatthis
badatthis
Posted Wednesday, June 30, 2010 2:19 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, June 07, 2013 11:59 AM
Points: 100,
Visits: 121
This may have been covered but can someone tell me why the answer says the order will be -1,-2,-3 since in the create table NO PK IS DEFINED? I understand that this is the order the data was inserted, but without a PK or more specificly a clustered index how can you be assured of the data sort order.
Post #945778
UMG Developer
UMG Developer
Posted Wednesday, June 30, 2010 2:40 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 2,163,
Visits: 2,151
badatthis: Yes, that issue has been brought up more than once. And I think it goes further than that, even with a PK/clustered index you aren't guaranteed a sort order unless you specify ORDER BY in your SELECT statement. (If I am wrong on this can somebody correct me?)
Post #945785
Ninja's_RGR'us
Ninja's_RGR'us
Posted Wednesday, June 30, 2010 4:06 PM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376,
Visits: 9,584
UMG Developer (6/30/2010)
badatthis: Yes, that issue has been brought up more than once. And I think it goes further than that, even with a PK/clustered index you aren't guaranteed a sort order unless you specify ORDER BY in your SELECT statement. (If I am wrong on this can somebody correct me?)
no you're right.
Post #945835
« Prev Topic
|
Next Topic »
145 posts, Page 14 of 15
««
«
11
12
13
14
15
»»
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.
