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 «««123

ALL Expand / Collapse
Author
Message
Posted Tuesday, July 1, 2008 7:24 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,406, Visits: 1,400
Nice questions ......


Post #526604
Posted Monday, March 16, 2009 1:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:55 AM
Points: 2,406, Visits: 202
Hi All

I am not sure wichi is correct answer. Beacuse the same question is repeted twice.

1st time i entered as 0 and answer was wrong.
2nd time i entered as 1 still anser was wrong saying it is 0

is this a valid question ?
Post #676303
Posted Monday, March 16, 2009 2:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:05 PM
Points: 6,043, Visits: 8,323
Balachandra (3/16/2009)
Hi All

I am not sure wichi is correct answer. Beacuse the same question is repeted twice.

1st time i entered as 0 and answer was wrong.
2nd time i entered as 1 still anser was wrong saying it is 0

is this a valid question ?


Hi Balachandra,

You have made a small reading mistake. The same question is not repeated twice; there is one small but important difference. The "first" question uses ANY, whereas the "second" (this) question uses ALL. These two keywords modify the meaning of the subquery in different ways; for that reason the question with ANY had 1 as the correct answer, and the question with ALL has 0 as the correct answer.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #676316
Posted Monday, March 16, 2009 2:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:55 AM
Points: 2,406, Visits: 202
Hi Hugo Kornelis,

Thanks a lot.
Post #676318
Posted Friday, December 7, 2012 4:19 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:54 AM
Points: 1,921, Visits: 2,345
nice +2


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

Add to briefcase «««123

Permissions Expand / Collapse