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, July 17, 2014 10:36 PM
Points: 5,308, Visits: 1,378
Nice questions ......


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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 3:09 AM
Points: 2,185, Visits: 192
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 @ 3:35 PM
Points: 5,930, Visits: 8,179
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: Tuesday, July 22, 2014 3:09 AM
Points: 2,185, Visits: 192
Hi Hugo Kornelis,

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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
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