if not null condition in sql server

Home / if not null condition in sql server / if not null condition in sql server

Anil Singh 5:01 AM if not null condition in sql server Edit

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