Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


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

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dee Pavali » NULL Values and Joins
Add to briefcase
42 posts, Page 1 of 5
12345»»»

NULL Values and Joins Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
SanDroid
Posted Saturday, December 18, 2010 3:23 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
Comments posted to this topic are about the item NULL Values and Joins
Post #1036927
Seth Kramer
Posted Saturday, December 18, 2010 11:49 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, January 11, 2013 8:30 AM
Points: 228, Visits: 179
I accept I got it wrong, but what do you mean the second transaction fails? Only the insert null into the primary key field statement fails. There are no failed inserts on Table2.
Post #1036950
Koen Verbeeck
Posted Sunday, December 19, 2010 6:37 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473
Nice question, but only 1 point?

Transactions and the NULL insert in the primary key have actually nothing to do with the actual question, they just serve as trickery in my opinion.
And I don't really get the last line of the explanation. B not C is the correct answer?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1036965
Stewart "Arturius" Campbell
Posted Monday, December 20, 2010 1:26 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 3,129, Visits: 4,312
The question itself is acceptable, but, in my opunion, the explanation is somewhat lacking.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1037061
vk-kirov
Posted Monday, December 20, 2010 1:32 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 3,192, Visits: 4,151
No rows were inserted into table2? B not C is the correct answer? Terrible, terrible explanation
Post #1037065
Carlo Romagnano
Posted Monday, December 20, 2010 1:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:56 AM
Points: 1,972, Visits: 1,822
vk-kirov (12/20/2010)
No rows were inserted into table2? B not C is the correct answer? Terrible, terrible explanation

The explanation is more terrible than the question: I should read it at least 7 times!
Post #1037066
philip.cullingworth
Posted Monday, December 20, 2010 2:17 AM
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: Tuesday, May 14, 2013 1:05 AM
Points: 754, Visits: 713
I have to disagree with the answer. I ran the code on SQL server 2005 and got the following output:
a	b	c	d
4	join1	4	join2
4	join1	4	join2
2	join3	2	one
2	join3	2	one
1	one	NULL	NULL
NULL	NULL	NULL	two
NULL	NULL	NULL	three

As I had worked out the same output before running and answering the question I decided that A, B, D and E could not possibly be correct so went for C as the only remaining option.

What have I missed?
Post #1037079
Koen Verbeeck
Posted Monday, December 20, 2010 2:26 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473
philip.cullingworth (12/20/2010)
I have to disagree with the answer. I ran the code on SQL server 2005 and got the following output:
a	b	c	d
4	join1	4	join2
4	join1	4	join2
2	join3	2	one
2	join3	2	one
1	one	NULL	NULL
NULL	NULL	NULL	two
NULL	NULL	NULL	three

As I had worked out the same output before running and answering the question I decided that A, B, D and E could not possibly be correct so went for C as the only remaining option.

What have I missed?


Your output has 7 rows and the column d contains "three" for the 7th row, so it should be answer D.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1037082
philip.cullingworth
Posted Monday, December 20, 2010 2:35 AM
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: Tuesday, May 14, 2013 1:05 AM
Points: 754, Visits: 713
da-zero (12/20/2010)

Your output has 7 rows and the column d contains "three" for the 7th row, so it should be answer D.


But Answer D is
7 rows where column d = three

I only have 1 row where column d = three
Post #1037083
Carlo Romagnano
Posted Monday, December 20, 2010 2:45 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:56 AM
Points: 1,972, Visits: 1,822
philip.cullingworth (12/20/2010)
da-zero (12/20/2010)

Your output has 7 rows and the column d contains "three" for the 7th row, so it should be answer D.


But Answer D is
7 rows where column d = three

I only have 1 row where column d = three

Please, read carefully the question: it asks how many rows are in the results and what is the value of column "d" on the last row.
Post #1037086
« Prev Topic | Next Topic »

Add to briefcase
42 posts, Page 1 of 5
12345»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.