if not null condition in sql server

I am going to share the example code for IF NOT NULL and the used condition for if not null in Sql Server as given below.

DECLARE @PRICINGID INT

SET @PRICINGID = NULL

IF @PRICINGID IS NULL

SELECT @PRICINGID

ELSE

SELECT 'NOT NULL'

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

if not null condition in sql server

Reviewed by Anil Singh on 5:01 AM Rating: (5)