June 29, 2010 at 7:23 am
Answer provided is wrong it should be -1, 0, 1
Else change the Identity to (-1,-1) to get the answer -1,-2,-3
June 29, 2010 at 7:39 am
Now that the points have been correctly awarded, those points received by discussion posts could be reduced: "Hey! I didn't get my point, I'll send ten posts to compensate..." :hehe:
June 29, 2010 at 7:42 am
It still says that -1,0,1 is wrong.
June 29, 2010 at 7:45 am
hilld (6/29/2010)
It still says that -1,0,1 is wrong.
I've said it before, I'll say it again - the question has been changed.
Read the changed text of the question on the website. You'll see that with this question, -1,-,1 is no longer a correct answer. -1,-2,-3 is. (As is -3,-2,-1).
June 29, 2010 at 7:46 am
Ok, they changed the question. How do I change my answer now?
June 29, 2010 at 8:04 am
hilld (6/29/2010)
Ok, they changed the question. How do I change my answer now?
You can't. You always have to check the question on the website before answering. I believe there is a warning message in the daily mail to that effect (I am at least pretty sure there used to be in the past)
June 29, 2010 at 8:06 am
hilld (6/29/2010)
Ok, they changed the question. How do I change my answer now?
Don't worry about it... chill!
June 29, 2010 at 8:47 am
The question comes out in email, but we cannot edit that. If we find a typo, which fix it on the site, which contains the updated question and the answers. This is one reason we don't put the answers in the newsletter.
If we find an issue, we mark the question correct for everyone to that point in time.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 29, 2010 at 8:53 am
Maybe if someone posts to the discussion to point out an error in the question, the system could somehow check if there are already 10 posts saying the same thing, and if so deduct a point from the poster instead of awarding one 😉
June 29, 2010 at 12:45 pm
Can the "Yesterday's question" and associated answer be edited prior to it being sent out?
June 29, 2010 at 12:51 pm
Once it's edited on the site, it will go out as the corrected version.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 29, 2010 at 12:53 pm
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: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 30, 2010 at 12:03 am
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 ?
June 30, 2010 at 8:33 am
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: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 30, 2010 at 10:53 am
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)
Viewing 15 posts - 121 through 135 (of 144 total)
You must be logged in to reply to this topic. Login to reply