Author Topic: What is the use of the NULLIF function?  (Read 427 times)

Offline Antony

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What is the use of the NULLIF function?
« on: October 24, 2014, 11:37:55 AM »
Hello, I would like to ask you a very urgent question to ask you, what is the use of the nullif function? Thank you, please, for your assistance in this matter.
« Last Edit: December 09, 2017, 06:03:47 PM by Sofyene »



Offline Jonathan

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: NULLIF function
« Reply #1 on: December 09, 2017, 06:04:35 PM »
Description

In SQL Server (Transact-SQL), the NULLIF function compares expression1 and expression2. If expression1 and expression2 are equal, the NULLIF function returns NULL. Otherwise, it returns the first expression which is expression1.

Syntax

The syntax for the NULLIF function in SQL Server (Transact-SQL) is:

NULLIF( expression1, expression2 )


 

Sitemap 1 2 3 4 5 6 7 8 9