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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.