Well , NULLIF and ISNULL may lookup similar, expacially working with several platforms at the same time. 😦
In T-SQL they are not equivalent, at all!
- NULLIF: Returns a null value if the two specified expressions are equal.
- ISNULL: Replaces NULL with the specified replacement value.
Is everything clear now? 😉