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