Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

OUTPUT & NEWID() Expand / Collapse
Author
Message
Posted Sunday, April 24, 2011 7:34 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:50 PM
Points: 2,717, Visits: 3,854
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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
Good question. Thanks

Mohammed Moinudheen
Post #1097892
Posted Sunday, April 24, 2011 9:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:50 PM
Points: 5,322, Visits: 25,235
From:
http://dictionary.reference.com/browse/guarantee

"something that assures a particular outcome or condition:"

Sorry but my language comprehension is that means the ONLY answers are 2 or 9 or 11 and NEVER another value.

But the given explanation is
Surprisingly, there can be any number of rows from ZERO to the number of rows in the table being deleted from


contradicts what is supposedly the correct answer.

Oh well, another question that does not rely on the workings of the database engine, but rather english comprehension.



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1097908
Posted Monday, April 25, 2011 1:51 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Thursday, September 11, 2014 9:05 AM
Points: 446, Visits: 152
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

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, March 10, 2014 9:39 AM
Points: 579, Visits: 27,690
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

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 20,572, Visits: 9,618
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

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, August 30, 2014 9:14 AM
Points: 1,258, Visits: 13,554
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.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1098064
Posted Monday, April 25, 2011 6:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 2, 2013 6:30 AM
Points: 346, Visits: 691
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

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 20,572, Visits: 9,618
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
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse