SQL 2008 T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » SQL 2008 T-SQL

20 posts, Page 1 of 2

1 2 »»

SQL 2008 T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

bitbucket-25253

Posted Thursday, August 20, 2009 11:26 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 PM
Points: 5,103, Visits: 20,208

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

Hugo Kornelis

Posted Friday, August 21, 2009 3:51 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 5,244, Visits: 7,059

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

paul.goldstraw

Posted Friday, August 21, 2009 4:41 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:38 AM
Points: 812, Visits: 1,134

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

kramaswamy

Posted Friday, August 21, 2009 5:22 AM

Right there with Babe

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:53 PM
Points: 785, Visits: 1,534

yeah, lucked out on getting it right, since both of those answers are technically correct.

Post #774929

dave.farmer

Posted Friday, August 21, 2009 6:50 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:39 AM
Points: 857, Visits: 584

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

David Betteridge

Posted Friday, August 21, 2009 6:51 AM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 3:33 PM
Points: 739, Visits: 1,566

I think answer 1 is correct as well!

David

Post #774994

Aluminum

Posted Friday, August 21, 2009 7:25 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:07 PM
Points: 353, Visits: 287

I just guessed. This one was way to much to think about.

Post #775040

Cliff Jones

Posted Friday, August 21, 2009 8:05 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 3,399, Visits: 3,408

Yes, please explain the difference between answers 1 and 2 because it is very subtle.

Post #775080

mtassin

Posted Friday, August 21, 2009 8:30 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 5:11 AM
Points: 3,229, Visits: 64,302

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

Scott Coleman

Posted Friday, August 21, 2009 8:32 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:39 PM
Points: 2,818, Visits: 1,038

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 »

20 posts, Page 1 of 2

1 2 »»

Permissions