• Home
  • About
SQiLler

Tag Archives: isnull

NULL vs IS NULL vs ISNULL()

Posted on July 17, 2014 by Hiram Romero

Many beginners on SQL often confuse these 3 terms in SQL, and it is truth they look very similar but their functionality is completely different and it is used for different things. Let’s start with the definition of NULL.

NULL is the absence of any value, but it is not 0 (zero) and it’s also not an empty string

. brain hurt

 

Continue reading “NULL vs IS NULL vs ISNULL()” »

Posted in SQL | Tags: difference, functions, is null, isnull, MSSQL, null, sql, TSQL | Leave a comment |

Stack Overflow

profile for sqiller on Stack Exchange, a network of free, community-driven Q&A sites

Recent Posts

  • English dictionary with synonyms
  • Create your own SQL log
  • Drop table if exists
  • Replace a value in all tables
  • Share temp tables to other sessions
Follow on Bloglovin

Pages

  • About

Archives

  • June 2015
  • August 2014
  • July 2014

Categories

  • SQL (23)

WordPress

  • Register
  • Log in
  • WordPress
CyberChimps

CyberChimps

© SQiLler