How to use =Null instead of is null

Question

Hi, How to use =Null instead of Is null in sql server. please tell me as soon as possible.

Shakti Singh Dulawat · Answer

Than I suggest you to go with NULLIF https://msdn.microsoft.com/en-us/library/ms177562.aspx IF NULLIF (@Parameter, '' ) IS NULL

Mamatha N · Answer

SET ANSI_NULLS OFF; DECLARE @checkParameter nvarchar(20)=null SELECT 1 WHERE @checkParameter =null

Satya Prakash Mishra · Answer

you can use nullable e.g. int ? num = null ;

Nitin Bhardwaj · Answer

it is possible. i have 25 parameter.

Shakti Singh Dulawat · Answer

At the top of your Stored Procedure you can check each parameter values from the functions and assign new values in SQL

Nitin Bhardwaj · Answer

But I have multiple parameter. and how to use it.

Shakti Singh Dulawat · Answer

Below function will help you to check if a parameter is NULL or NOT NULL CREATE FUNCTION dbo.IsNullOrEmpty (@x varchar ( max )) returns bit as BEGIN IF @SomeVarcharParm IS NOT NULL AND LEN(@SomeVarcharParm) > 0 RETURN 0 ELSE RETURN 1 END

Nitin Bhardwaj · Answer

But i am passing parameter value from application. it might be null or not null. so we can't write this query.

Shakti Singh Dulawat · Answer

if(exists( select top 1 Id from table where Parameter IS NULL ) This one is not working for you?

Nitin Bhardwaj · Answer

Actually I wann to check record exists or not with passing null parameter. example: @checkParameter nvarchar(20)=null if(exists(select top 1 Id from table where Parameter=@checkParameter )

Shakti Singh Dulawat · Answer

Any reason behind using -=NULL? Best way to use is IS Not NULL or IS NULL Please check MSDN Document https://msdn.microsoft.com/en-us/library/ms188795.aspx

How to use =Null instead of is null

Answers (11)