Skip to main content

Posts

Showing posts with the label 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'