SQL NULL Functions
SQL ISNULL(), NVL(), IFNULL() and COALESCE() Functions
Look at the following "Products" table:
Suppose that the "UnitsOnOrder" column is optional, and may contain NULL values.
We have the following SELECT statement:
In the example above, if any of the "UnitsOnOrder" values are NULL, the result is NULL.
Microsoft's ISNULL() function is used to specify how we want to treat NULL values.
The NVL(), IFNULL(), and COALESCE() functions can also be used to achieve the
In this case we want NULL values to be zero.
Below, if "UnitsOnOrder" is NULL it will not harm
the calculation, because ISNULL() returns a zero if the value is NULL:
SQL Server / MS Access
Oracle does not have an ISNULL() function. However, we can use the NVL() function
to achieve the same result:
MySQL does have an ISNULL() function. However, it works a little bit
different from Microsoft's ISNULL() function.
In MySQL we can use the IFNULL() function, like this:
or we can use the COALESCE() function, like this:
Learn how your website performs under various load conditions
is a load, stress and performance testing tool for websites and web-based applications.
In contrast to "800-pound gorilla" load testing tools, it is designed to minimize the learning
curve and give you an ability to create a heavy load from a regular workstation.
WAPT is able to generate up to 3000 simultaneously acting virtual users using standard hardware configuration.
Virtual users in each profile are fully customizable. Basic and NTLM authentication methods are supported.
Graphs and reports are shown in real-time at different levels of detail, thus helping to manage the testing process.
Download the free 30-day trial!