Answers for "diffrent ways to replaceis null in sql server"

diffrent ways to replaceis null in sql server

/* deffrent ways to replace null in
isnull() function 
case statement 
coalecse() function*/
SELECT Aliase_Name.Column_Name AS IS NULL(Aliase_Name.Column_Name, "Message") AS Column_Name
FROM Left_Table_Name Aliase _Name
JOIN_TYPE Right_Table _Name  Aliase_Name
ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name

/*............*/
SELECT Aliase_Name.Column_Name AS Aliase_Name
		CASE 
            WHEN ALiase_Name IS NULL THEN "Message" ELSE ALiase_Name.Column_Name
        END 
        AS Aliase_Name
FROM Left_Table_Name Aliase _Name
JOIN_TYPE Right_Table _Name  Aliase_Name
ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name

/*...........*/
SELECT Aliase_Name.Column_Name AS COALESCE (Aliase_Name.Column_Name, "Message") AS Column_Name
FROM Left_Table_Name Aliase _Name
JOIN_TYPE Right_Table _Name  Aliase_Name
ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name