ISNULL :

Return the specified value IF the expression is NULL, otherwise return the expression

Select isnull(coulumnname,value)

select isnull(salary,0) from emp

COALESCE :

Return the first non-null value in a list:

SELECT COALESCE(coumn1,column2,.....,columnn) from tablename

select coalesce(mgr,salary) from emp