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 Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.