3
Answers

check column is null or not null in conditional?

Photo of Ramesh

Ramesh
3y
696
1 SQL

Hi everyone, how to check column is null or not null in conditional?
I need to convert Dynamic to Static SQL

Dynamic SQL:

IF @typeWeb = 1
       BEGIN
           SET @where = @where + ' AND p.Dealer is null '
       END
ELSE
IF @typeWeb = 0
       BEGIN
           SET @where = @where + ' AND p.Dealer is not null '
       END

How can i type this code?

Answers (3)