Question of the Day for 23 May 2007

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Testing Center » Question of the Day (QOD) » Question of the Day for 23 May 2007

Add to briefcase

13 posts, Page 2 of 2

««1 2

Question of the Day for 23 May 2007

Expand / Collapse

Author

Message

Steve Jones - SSC Editor

Posted Friday, May 25, 2007 8:22 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:46 PM
Points: 31,433, Visits: 13,745

Girish, that is not the case in logical operations. With an AND, only one operand is required to be false to give false. So if one side is false, it doesn't matter if the other side is true or false, which are the two possible values for Unknown. It's unknown.

Just as with an OR. If one side is true, it does not matter if the other side is true.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #369034

Posted Monday, September 24, 2007 11:42 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:27 PM
Points: 21,357, Visits: 9,537

You can run this query to test it yourself :

SELECT 1 WHERE NOT(0 = 1 AND NULL = NULL)

I screwed this one up because I had put (1 = 1), therefore not testing the actual question :).

Post #402175

Posted Tuesday, November 27, 2012 5:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061, Visits: 1,151

good one

Post #1389124

« Prev Topic | Next Topic »

Add to briefcase

13 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse