locked
ignore null value in import excel file in sql server RRS feed

  • Question

  • User-1482093223 posted

    Hi,

    I am importing excel data in sql server using asp.net c#, some time null value inserted in sql server, how can i check null value in select statement..

    thanks in advance

    Saturday, August 10, 2013 5:31 AM

All replies

  • User269602965 posted

    If bird_count is null, it returns value 0

    MS SQL

    SELECT ISNULL(BIRD_COUNT,0) AS BIRD_COUNT FROM ANIMAL_INVENTORY

    ORACLE

    SELECT NVL(BIRD_COUNT,0) AS BIRD_COUNT FROM ANIMAL_INVENTORY

    MYSQL

    SELECT IFNULL(BIRD_COUNT,0) AS BIRD_COUNT FROM ANIMAL_INVENTORY

     

    Saturday, August 10, 2013 11:46 PM