Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 OUTPUT & NEWID() Rate Topic Display Mode Topic Options
Author
 Message
 Posted Sunday, April 24, 2011 7:34 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, December 6, 2016 8:39 AM Points: 2,777, Visits: 4,100
 Comments posted to this topic are about the item OUTPUT & NEWID() ______________________________________________________________________Personal Motto: Why push the envelope when you can just open it?If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.Jason L. Selburg
Post #1097891
 Posted Sunday, April 24, 2011 7:34 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, October 18, 2016 8:46 PM Points: 2,333, Visits: 3,896
 Good question. Thanks M&M
Post #1097892
 Posted Sunday, April 24, 2011 9:00 AM
 SSCertifiable Group: General Forum Members Last Login: Sunday, January 4, 2015 7:55 AM Points: 5,333, Visits: 25,280
Post #1097908
 Posted Monday, April 25, 2011 1:51 AM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Wednesday, March 2, 2016 3:02 AM Points: 561, Visits: 179
 Hello,I think the correct answer is none of the above, because the result can be 8 for example,and any of the above means the result must be 2 , 9 or 11 and not another value.anywhere thanks for the question.
Post #1097990
 Posted Monday, April 25, 2011 3:03 AM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Monday, April 13, 2015 4:52 AM Points: 579, Visits: 27,695
 I answered "None of the above". After getting the explanation I still claim I answered right. The question was "... how many rows are gauranteed ...", so answer "Any of the above", well, questionable.Interesting question though
Post #1097999
 Posted Monday, April 25, 2011 5:50 AM
 SSC-Insane Group: General Forum Members Last Login: Wednesday, April 13, 2016 12:23 AM Points: 20,643, Visits: 9,671
 Echoing here... since you're talking about garanteed # of rows, none is the only possible answer.
Post #1098053
 Posted Monday, April 25, 2011 6:14 AM
 SSCommitted Group: General Forum Members Last Login: Monday, September 16, 2013 8:08 AM Points: 1,987, Visits: 210
 Jeez, I hate it when the answer depends more on figuring out the author's intent in the answer than actually answering the question.If the answer is any number of rows can be returned, then 2, 9, or 11 are NOT guaranteed.
Post #1098061
 Posted Monday, April 25, 2011 6:27 AM
 Ten Centuries Group: General Forum Members Last Login: Friday, November 25, 2016 5:31 AM Points: 1,265, Visits: 13,618
 great question! Initially, I analyzed the text in question and then I found the command's return is not fixed, after running it several times, really it can be any value according the correct answer. rfr.ferrariDBA - SQL Server 2008MCITP | MCTS remember is live or suffer twice!the period you fastest growing is the most difficult period of your life!
Post #1098064
 Posted Monday, April 25, 2011 6:55 AM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Wednesday, November 30, 2016 2:37 PM Points: 534, Visits: 1,102
 Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?Unless I'm crazy you can't insert 'a' into the nDex field because nDex is an integer. When that script is copied to SSMS you get 3 incorrect sytax errors.So the correct answer is "none of the above". :) Because it's *guaranteed* you won't get any return values!
Post #1098075
 Posted Monday, April 25, 2011 7:15 AM
 SSC-Insane Group: General Forum Members Last Login: Wednesday, April 13, 2016 12:23 AM Points: 20,643, Visits: 9,671
 roger.plowman (4/25/2011)Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?Unless I'm crazy you can't insert 'a' into the nDex field because nDex is an integer. When that script is copied to SSMS you get 3 incorrect sytax errors.So the correct answer is "none of the above". :) Because it's *guaranteed* you won't get any return values!The insert will fail in 2k5, you have to change it to union alls... other than that the script will work (tho not as obviously intented and hence the question here)
Post #1098086

 Permissions