if not null condition in sql server

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'
ANIL SINGH

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 if not null condition in sql server Reviewed by Anil Singh on 5:01 AM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^