What will be the output of the following?

Question

Post reply

What will be the output of the following?

Viewing 15 posts - 121 through 135 (of 144 total)

You must be logged in to reply to this topic. Login to reply

vssridhar Newbie Points: 5 More actions · Answer 1

Answer provided is wrong it should be -1, 0, 1

Else change the Identity to (-1,-1) to get the answer -1,-2,-3

Arsi Salo Ten Centuries Points: 1313 More actions · Answer 2

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:

hilld SSC Enthusiast Points: 123 More actions · Answer 3

hilld

SSC Enthusiast

Points: 123

June 29, 2010 at 7:42 am

#1186378

It still says that -1,0,1 is wrong.

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 4

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).

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

hilld SSC Enthusiast Points: 123 More actions · Answer 5

Ok, they changed the question. How do I change my answer now?

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 6

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)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

david.wright-948385 SSCarpal Tunnel Points: 4039 More actions · Answer 7

hilld (6/29/2010)
Ok, they changed the question. How do I change my answer now?

Don't worry about it... chill!

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 8

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.

Toreador SSChampion Points: 11358 More actions · Answer 9

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 😉

Nadrek SSC-Insane Points: 20039 More actions · Answer 10

Can the "Yesterday's question" and associated answer be edited prior to it being sent out?

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 11

Once it's edited on the site, it will go out as the corrected version.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 12

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.

dhirendra.singh Newbie Points: 2 More actions · Answer 13

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 ?

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 14

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.

sadowy Valued Member Points: 58 More actions · Answer 15

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)