Mohit Agrawal

Success is Journey it's not a destination

Menu

  • Home
  • Sql server 2008
  • Differences

October 3, 2012

NULLIF function


The NULLIF function compares the first parameter (variableB) with second parameter (0). If they are same, it returns a NULL .

Example :

Declare @variableA int 
Declare @variableB int
select @variableA=50, @variableB=0


select @variableA/NULLIF (@variableB,0)

Output:
NULL
Posted by Mohit No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Sql Server
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Index

  • ►  2017 (1)
    • ►  February (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2014 (2)
    • ►  March (2)
  • ►  2013 (1)
    • ►  January (1)
  • ▼  2012 (3)
    • ►  December (1)
    • ▼  October (1)
      • NULLIF function
    • ►  February (1)
  • ►  2011 (1)
    • ►  March (1)
  • ►  2010 (4)
    • ►  May (2)
    • ►  March (2)
  • ►  2009 (22)
    • ►  November (1)
    • ►  October (6)
    • ►  August (3)
    • ►  July (2)
    • ►  June (3)
    • ►  May (3)
    • ►  March (4)
  • ►  2008 (17)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  April (2)
    • ►  February (12)
Mohit
View my complete profile

Blogs

  • AngularJS
  • Asp.net
  • Vb.net Link
  • Obect Oriented Programming
Ethereal theme. Powered by Blogger.