Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
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?
Add to briefcase
145 posts, Page 1 of 15
12345»»»

What will be the output of the following? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
bazzkar
Posted Saturday, June 26, 2010 11:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 03, 2010 4:19 AM
Points: 158, Visits: 72
Comments posted to this topic are about the item What will be the output of the following?
Post #943474
Paarthasarathy
Posted Saturday, June 26, 2010 11:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 09, 2010 9:02 AM
Points: 153, Visits: 90
how come.. i am getting -1,0,1 only..
someone explain please

Kindest Regards,
Paarthasarathy
Microsoft Certified Technology Specialist
http://paarthasarathyk.blogspot.com
Post #943476
Piotr Ryszkowski
Posted Sunday, June 27, 2010 4:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 27, 2011 9:10 AM
Points: 1,814, Visits: 60
first - all available answers are wrong. "-1,-0,1" is the better looking although you will not get "-0"
second - with identity (-1,1) you can only get -1, 0, 1. If you want to get -1,-2,-3 you would need identity(-1,-1)
There is something wrong with either question or with the answers.
Post #943536
sheik
Posted Sunday, June 27, 2010 8:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:25 AM
Points: 93, Visits: 93
The table should be created with the identity (-1,-1). Then only we can get this result. Must be a typo error???.
Post #943546
john-byrne
Posted Sunday, June 27, 2010 9:51 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 24, 2012 7:42 PM
Points: 635, Visits: 18
Since the question is wrong then everyone who selected "-1,0,1" should get a point!
Post #943628
bhandari220
Posted Sunday, June 27, 2010 10:10 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 22, 2011 4:53 AM
Points: 396, Visits: 23
Yes, To get -1,-2,-3 identity should be -1 insteed of 1.

Regards,
Pankaj Bhandari
Microsoft Certified Technology Specialist
Post #943632
ziangij
Posted Sunday, June 27, 2010 10:33 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:53 AM
Points: 1,526, Visits: 359
Yeah!... i have executed the query in SSMS 2005... and I get the result as "-1,0,1"

we should get our points back...

john-byrne (6/27/2010)
Since the question is wrong then everyone who selected "-1,0,1" should get a point!
Post #943637
Nakul Vachhrajani
Posted Sunday, June 27, 2010 10:39 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:52 AM
Points: 1,277, Visits: 1,608
With an identity of (-1,1), -1, -2 and -3 is just not the possible output.

The first record that goes in will have -1. Next would be -1 + 1 = 0. Finally, we would have 0 + 1 = 1.

It's probably just a typo, and I am sure the moderators will take a look and award the points.

The points not being awarded is a typical drawback with the automated evaluation systems - after all, all automation works on GIGO. If there was an error in framing the question, there's bound to be an error in the evaluation. Just another example of why automation should not be allowed work without supervision :)

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 #943638
sumedha_2001jhanji
Posted Sunday, June 27, 2010 11:14 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 29, 2010 12:09 AM
Points: 76, Visits: 9
The answer is -1,0,1. The provided answer is wrong. To get -1,-2,-3, we have to set the identity increment as -1.

Juts give the points... 10 times of the actual point.....
Post #943643
chetanr.jain
Posted Sunday, June 27, 2010 11:30 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 6:47 AM
Points: 465, Visits: 436
Even i am getting the answer as "-1, 0, 1".
I have executed the query in SQL 2008 Enterprise edition.

i am agreeing with others about the fact that
to get ans as -1, -2, -3, the seed value should be -1.

@Moderator :
Look in this.
Post #943645
« Prev Topic | Next Topic »

Add to briefcase
145 posts, Page 1 of 15
12345»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.