SQL OR

[ice7899]

Am I right in thinking that if the first expression in an or statement evaluates to true then the second part is not tested

For example

if(a = 10 or b = 20)
Print 'Message'

Here, if a = 10 then Message is printed without evaluating b

 

[SQLDenis]

why don't you test it?

declare @a int,@b int
select @a =10,@b=666

if(@a = 10 or @b = 20)
Print 'Message'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/