what does NULLIF() do ? how is it different from ISNULL()?
September 14th, 2010
No comments
NULLIF( ) : Returns a null value if the two expressions specified in the function are equal.
The syntax used is
NULLIF ( expression1 ,expression2 )
If expression1 = expression2, then the function will return NULL.
ISNULL( ): The function replaces a null expressions with a specified value.
The syntax used is
Categories: Error Messages, Functions and DMVs, SQL Queries, SQL Server, T-SQL, Tips & Tricks functions, Geekepisodes, ISNull(), NullIF(), SQL, SQL Server, T-SQL