How to use =Null instead of is null

Nitin Bhardwaj

10y1k

Hi,

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

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shakti Singh Dulawat10y ago
Accepted answer
Than I suggest you to go with NULLIF
https://msdn.microsoft.com/en-us/library/ms177562.aspx
IFNULLIF(@Parameter,'')ISNULL
0
Mamatha N10y ago
SET ANSI_NULLS OFF;
DECLARE @checkParameter nvarchar(20)=null
SELECT 1 WHERE @checkParameter =null
0
Satya Prakash Mishra10y ago
you can use nullable e.g.
int? num = null;
0
Nitin Bhardwaj10y ago
it is possible. i have 25 parameter.
0
Shakti Singh Dulawat10y ago
At the top of your Stored Procedure you can check each parameter values from the functions and assign new values in SQL
0
Nitin Bhardwaj10y ago
But I have multiple parameter. and how to use it.
0
Shakti Singh Dulawat10y ago
Below function will help you to check if a parameter is NULL or NOT NULL
CREATE FUNCTION dbo.IsNullOrEmpty (@xvarchar(max))returns bitas
BEGIN
IF @SomeVarcharParm IS NOT NULL AND LEN(@SomeVarcharParm) > 0
RETURN 0
ELSE
RETURN 1
END
0
Nitin Bhardwaj10y ago
But i am passing parameter value from application. it might be null or not null. so we can't write this query.
0
Shakti Singh Dulawat10y ago
if(exists(select top 1 Id from table where Parameter IS NULL)

This one is not working for you?
0
Nitin Bhardwaj10y ago
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 )
0
Shakti Singh Dulawat10y ago
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
0