Click here to Skip to main content
15,064,665 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL boolean comparison Pin
Richard MacCutchan26-Jul-17 22:48
mveRichard MacCutchan26-Jul-17 22:48 
JokeRe: SQL boolean comparison Pin
User 1106097926-Jul-17 23:14
MemberUser 1106097926-Jul-17 23:14 
GeneralRe: SQL boolean comparison Pin
User 1106097927-Jul-17 22:40
MemberUser 1106097927-Jul-17 22:40 
GeneralRe: SQL boolean comparison Pin
Richard MacCutchan27-Jul-17 22:59
mveRichard MacCutchan27-Jul-17 22:59 
GeneralRe: SQL boolean comparison Pin
Member 133967936-Sep-17 14:04
MemberMember 133967936-Sep-17 14:04 
AnswerRe: SQL boolean comparison Pin
Mycroft Holmes26-Jul-17 22:23
professionalMycroft Holmes26-Jul-17 22:23 
GeneralRe: SQL boolean comparison Pin
User 1106097926-Jul-17 22:42
MemberUser 1106097926-Jul-17 22:42 
AnswerRe: SQL boolean comparison Pin
Richard Deeming27-Jul-17 1:41
mveRichard Deeming27-Jul-17 1:41 
You need a logical operator to combine two boolean conditions.

In this example, you'd want the Xor operator. But unfortunately, MS SQL Server doesn't support it; it only provides a bitwise Xor operator, which won't work here.

You can either use CASE, as Mycroft suggested, or the longhand version of Xor:
a XOR b <==> (a AND (NOT b)) OR ((NOT a) AND b)
SQL
... WHERE ((TBL1.INTFIELD Is Null And TBL2.INTFIELD Is Not Null) Or (TBL1.INTFIELD Is Not Null And TBL2.INTFIELD Is Null))




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: SQL boolean comparison Pin
User 1106097927-Jul-17 1:53
MemberUser 1106097927-Jul-17 1:53 
GeneralRe: SQL boolean comparison Pin
User 1106097927-Jul-17 22:41
MemberUser 1106097927-Jul-17 22:41 
QuestionSQL Linq, getting 3 of each record. Pin
jkirkerx24-Jul-17 10:16
professionaljkirkerx24-Jul-17 10:16 
AnswerRe: SQL Linq, getting 3 of each record, [WAIT] Pin
jkirkerx24-Jul-17 10:29
professionaljkirkerx24-Jul-17 10:29 
JokeRe: SQL Linq, getting 3 of each record, [WAIT] Pin
Afzaal Ahmad Zeeshan24-Jul-17 10:40
mveAfzaal Ahmad Zeeshan24-Jul-17 10:40 
AnswerRe: SQL Linq, getting 3 of each record. Pin
Afzaal Ahmad Zeeshan24-Jul-17 10:36
mveAfzaal Ahmad Zeeshan24-Jul-17 10:36 
QuestionIF then ? Pin
patsq19-Jul-17 12:00
Memberpatsq19-Jul-17 12:00 
AnswerRe: IF then ? Pin
PIEBALDconsult19-Jul-17 13:01
professionalPIEBALDconsult19-Jul-17 13:01 
QuestionRe: IF then ? Pin
Richard MacCutchan19-Jul-17 21:51
mveRichard MacCutchan19-Jul-17 21:51 
AnswerRe: IF then ? Pin
patsq20-Jul-17 2:23
Memberpatsq20-Jul-17 2:23 
AnswerRe: IF then ? Pin
Richard Deeming20-Jul-17 1:36
mveRichard Deeming20-Jul-17 1:36 
GeneralRe: IF then ? Pin
Chris Quinn20-Jul-17 5:59
MemberChris Quinn20-Jul-17 5:59 
GeneralRe: IF then ? Pin
Richard Deeming20-Jul-17 6:50
mveRichard Deeming20-Jul-17 6:50 
GeneralRe: IF then ? Pin
Chris Quinn20-Jul-17 21:22
MemberChris Quinn20-Jul-17 21:22 
GeneralRe: IF then ? Pin
Richard Deeming21-Jul-17 0:15
mveRichard Deeming21-Jul-17 0:15 
AnswerRe: IF then ? Pin
Pradeep Magati11-Aug-17 2:58
MemberPradeep Magati11-Aug-17 2:58 
QuestionSetting values from a Pivot to 0? Pin
patsq18-Jul-17 4:55
Memberpatsq18-Jul-17 4:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.