SQL Server Performance

ISNull and IS Null

Discussion in 'SQL Server 2008 General DBA Questions' started by RVG, Jan 14, 2010.

  1. RVG Member

    What is the difference between isnull and is null?
    thanks&regards,
    RVG
    RVG, Jan 14, 2010
    #2

  2. moh_hassan20 New Member

    isnull is a function Replaces NULL with the specified value.
    example
    declare @qty int
    set @qty = null
    select ISNULL (@qty,0) -- replace qty with 0
    result : 0

    IS NULL : is operator to check whether a specified expression is NULL in sql statements

    SELECT id, Name
    FROM emp
    WHERE name IS NULL

    moh_hassan20, Jan 14, 2010
    #3

  3. RVG Member

    Thanks Mr.Hassan..
    RVG, Jan 15, 2010
    #4

Share This Page