Daily Archives: September 2, 2014

Difference between ISNULL and COALESCE (SQL Server)

Though ISNULL and COALESCE can be interchangeably used in common scenarios basic functionality of ISNULL and COALESCE are different. ISNULL: ISNULL Accepts 2 parameters, if the first parameter is NULL, second parameter value will be returned. COALESCE: COALESCE accepts multiple … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , | Leave a comment