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

Question of the Day for 08 May 2007 Expand / Collapse
Author
Message
Posted Friday, April 20, 2007 6:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the Question of the Day for 08 May 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1029.
Post #360105
Posted Monday, May 14, 2007 9:28 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: Yesterday @ 11:39 AM
Points: 509, Visits: 246
So, what's wrong with this answer: "This returns all rows and all columns from both tables?"
 
  I think the wording on the "correct" answer, "This returns all rows from both tables, replacing the values for columns with NULL when a row does not have a match in a table", was a horrible rendition of the Microsoft documentation which states that "Any time a row has no match in the other table, the select list columns from the other table contain null values"
 



Post #365673
Posted Monday, May 14, 2007 5:01 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:26 AM
Points: 2,953, Visits: 439
I agree with you. Even the first option "This returns all combinations of all rows in both tables based on the columns joined in the ON clause." is correct as well IMO. Non-matching rows is part of a combination. I just think the options are a bit vague.


Urbis, an urban transformation company
Post #365808
Posted Tuesday, May 15, 2007 8:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 27, 2014 12:38 PM
Points: 1,922, Visits: 400
I completely agree with the previous comments. The options were poorly worded.
Post #366000
Posted Tuesday, September 25, 2007 2:19 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 8:30 AM
Points: 769, Visits: 191
I have to agree on this one. Most of the answers would have been correct.
Post #402740
Posted Tuesday, November 27, 2012 5:31 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,936, Visits: 2,369
got excite to see such a simple question and clicked on wrong option


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1389123
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse