The isnull function requires 2 argument(s).

Question

0.00/5 (No votes)

See more:

Hello Everyone,
I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL,
after performing this query:

IIf(IsNull(EventSummary.[Event Information - Event Status]),"ACTIVE",EventSummary.[Event Information - Event Status]) AS [Event Status],

I get this error message:
Msg 174, Level 15, State 1, Line 2
The isnull function requires 2 argument(s).

I just want to perform a query that will select the event status, check if it is null, if it is null, then value of event status should be active, else, just copy the value of event status.

I hope you can help me.
Thanks.

Posted 28-Jul-11 3:46am

serigraphie

Add a Solution

3 solutions

Solution 1

Dear it contains 2 arguments....

VB

ISNULL ( check_expression , replacement_value )

SQL

check_expression
    Is the expression to be checked for NULL. check_expression can be of any type.
replacement_value
    Is the expression to be returned if check_expression is NULL. replacement_value must be of a type that is implicitly convertible to the type of check_expresssion.

Posted 28-Jul-11 3:49am

saxenasanket

Comments

serigraphie 28-Jul-11 10:00am

Hi, I truly appreciate your reply, so you mean my code does not supply two argumanets needed?
Thank you so much

Solution 3

you would use the isnull() function to replace the null values from your query with a default value. for example

VB

create table #temp
(
 IntValue int
)

insert into #temp values (0)
insert into #temp values (1)
insert into #temp values (2)
insert into #temp values (null)
insert into #temp values (3)

select IntValue
from #temp

select isnull(IntValue,-100)
from #temp

what I think your after is something like this

SQL

declare @value int
set @value = null

if @value is null then
 print 'Value is nothing'
end if

Hope this clears up the different definitions of is null

Posted 28-Jul-11 4:29am

Simon_Whale

Updated 28-Jul-11 5:16am

v2

Comments

Manas Bhardwaj 28-Jul-11 11:18am

nicely done. +5

Simon_Whale 28-Jul-11 11:35am

Thanks :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Accepted Answer · 2011-07-28T03:53:00

Solution 2

I think you're confusing the ISNULL() function with IS NULL

The former will do the replacement for you ISNULL(eventInfo,"ACTIVE") the latter gives a boolean result and could be used in your IF statement

Posted 28-Jul-11 3:53am

barneyman

Comments

serigraphie 28-Jul-11 10:01am

so there is another function called "is null" which is different than "ISNULL()" functions?