<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Jason Selburg
»
OUTPUT & NEWID()
56 posts, Page 1 of 6
1
2
3
4
5
»
»»
OUTPUT & NEWID()
Rate Topic
Display Mode
Topic Options
Author
Message
Jason Selburg
Jason Selburg
Posted Sunday, April 24, 2011 7:34 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:55 AM
Points: 2,582,
Visits: 3,552
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
mohammed moinudheen
mohammed moinudheen
Posted Sunday, April 24, 2011 7:34 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:28 AM
Points: 2,170,
Visits: 3,583
Good question. Thanks
Mohammed Moinudheen
Post #1097892
bitbucket-25253
bitbucket-25253
Posted Sunday, April 24, 2011 9:00 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 5,103,
Visits: 20,213
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
khelloufsofiane 6183
khelloufsofiane 6183
Posted Monday, April 25, 2011 1:51 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 5:03 AM
Points: 375,
Visits: 125
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
Brigadur
Brigadur
Posted Monday, April 25, 2011 3:03 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, April 01, 2013 10:11 AM
Points: 576,
Visits: 27,680
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
Ninja's_RGR'us
Ninja's_RGR'us
Posted Monday, April 25, 2011 5:50 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
Echoing here... since you're talking about garanteed # of rows, none is the only possible answer.
Post #1098053
Richard Sisk
Richard Sisk
Posted Monday, April 25, 2011 6:14 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:19 AM
Points: 1,879,
Visits: 205
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
rfr.ferrari
rfr.ferrari
Posted Monday, April 25, 2011 6:27 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219,
Visits: 13,507
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
roger.plowman
roger.plowman
Posted Monday, April 25, 2011 6:55 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 317,
Visits: 619
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
Ninja's_RGR'us
Ninja's_RGR'us
Posted Monday, April 25, 2011 7:15 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
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 »
56 posts, Page 1 of 6
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
