isnull and SELECT statements

Question

isnull and SELECT statements

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

I think it depends as the select statement should use it's where clause to get the data together. ISNULL is checking that the one value is null or not. As will only be a single value no index would be needed. I am assumeing you are speaking of something like this.

IF ISNULL(SELECT [wife] FROM emp WHERE firstname = 'BOB' AND lastname = 'Hogan')

In this case the select statement will use it's index.

Are you referring to a specific way of using ISNULL other than this?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

sbendayan SSCommitted Points: 1791 More actions · Answer 2

No, that's it....you answered my question. Thanks

sbendayan SSCommitted Points: 1791 More actions · Answer 3

No, that's it....you answered my question. Thanks