Sp Null

[farshad]

In vb.net i am running a stored procedure in sql server 2000

the SP is something like:

 

@Curve int

.

.

.

@Qualifier varchar(3) = NULL

AS

select * from table1 where

curve=@Curve

.

.

.

AND Qualifier = @Qualifier

 

Basically the question is that when i run the query like select * from table1 where Qualifier IS NULL

it works and returns data but in SP when no @Qualifier is passed then it becomes select * from table1 where Qualifier = NULL

 

when it is = null it does not return data

and thoughts?

thanks

[PlausiblyDamp]

= NULL will always return NULL.

 

Probably the easiest way is alter the SP so that you check for NULL and act accordingly

 

i.e.

Create proc 
.
.
.
.
AS

if @Qualifier is NULL
Begin
   --Code to handle NULL here
   select * from table1 where
   curve=@Curve
   .
   .   
   .
AND Qualifier IS NULL
End
Else
Begin
   --Non Null here
select * from table1 where
curve=@Curve
   .
   .
   .
   AND Qualifier = @Qualifier
End