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'