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

Question of the Day for 23 May 2007 Expand / Collapse
Author
Message
Posted Friday, May 25, 2007 8:22 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:00 PM
Points: 33,204, Visits: 15,354
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

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:00 AM
Points: 21,397, Visits: 9,612
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
good one


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1389124
Posted Monday, August 25, 2014 4:43 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:37 PM
Points: 2,677, Visits: 215
Got me on that one.
Post #1607289
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse