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: Thursday, April 10, 2014 3:50 PM
Points: 504, Visits: 228
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: Tuesday, January 28, 2014 5:31 PM
Points: 2,953, Visits: 435
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, April 07, 2014 9:37 AM
Points: 1,914, Visits: 391
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 05, 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: Monday, April 14, 2014 11:50 PM
Points: 1,868, Visits: 2,275
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