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 12»»

SQL 2008 T-SQL Expand / Collapse
Author
Message
Posted Thursday, August 20, 2009 11:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
Comments posted to this topic are about the item SQL 2008 T-SQL

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 #774782
Posted Friday, August 21, 2009 3:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:18 PM
Points: 6,056, Visits: 8,342
I got my points, due to a lucky 50/50 guess. But I'd still like to know, what eexactly is the difference between
DeptId 2 data was updated,Deptid 5 row was deleted,A new Deptid of 6 was added
and
Deptid 1 no changes,DeptId 2 data was updated,Deptid 5 was deleted,A new Deptid of 6 was added
?



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #774871
Posted Friday, August 21, 2009 4:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 1,107, Visits: 1,465
And I was the unlucky one who guessed the other way and got it wrong. Answers 1 and 2 are the same, but imo answer 1 is more correct, since the question asked

What actions were executed in/on the rows in the Depts table?


Since no actions were executed on row 1 it should have been omitted.
Post #774895
Posted Friday, August 21, 2009 5:22 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:25 AM
Points: 826, Visits: 1,689
yeah, lucked out on getting it right, since both of those answers are technically correct.
Post #774929
Posted Friday, August 21, 2009 6:50 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, June 11, 2014 9:54 AM
Points: 912, Visits: 654
Wrong here too - I spent a lot of time deciding between answer 1 and 2, and as Paul mentioned above, plumped for 1 as the question asked about actions and no action was taken with row 1 so it shouldn't be mentioned.

Of course I knew I'd be wrong. I seem to have the unenviable knack of choosing the wrong one whenever there are multiple correct answers, and every time I do, I vow to give up on these questions - and by the next day I'm back, getting the wrong right answer yet again! :-{
Post #774993
Posted Friday, August 21, 2009 6:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 1:42 AM
Points: 941, Visits: 1,758
I think answer 1 is correct as well!

David
Post #774994
Posted Friday, August 21, 2009 7:25 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 12:42 PM
Points: 413, Visits: 310
I just guessed. This one was way to much to think about.
Post #775040
Posted Friday, August 21, 2009 8:05 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: Tuesday, October 28, 2014 7:37 AM
Points: 3,969, Visits: 3,646
Yes, please explain the difference between answers 1 and 2 because it is very subtle.
Post #775080
Posted Friday, August 21, 2009 8:30 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: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
I agree... I got this one right, but I was torn between the equivacy of answer 1 and 2.

1 makes no mention of row 1, hence it is left alone.
2 distinctly states that nothing will happen to row 1... which equates to answer 1.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #775107
Posted Friday, August 21, 2009 8:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:04 PM
Points: 2,845, Visits: 1,158
How on earth can you claim "no changes" is an action that was executed?

I'm really getting tired of questions that play word games.



Post #775109
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse