Check for Null or Empty In SP

[siva455]

Hi, Please let me know how can i check whether the i/p parameters were Null or empty and raise error and let user know that particular parameter is null or empty when he is trying to execute the SP (Stored procedure)....

[Wendelius]

You mean inside the stored procedure? You can use IS NULL operator:

create procedure foo @param1 decimal as
begin
if @param1 is null
begin
raiserror('param1 is null', 16, 1);
end;
end;

exec foo 1;

exec foo null;

The need to optimize rises from a bad design.My articles[^]

[PIEBALDconsult]

Yes, what Mika said, but you're still better off wrapping a Data Access Layer around your database to check things like that.

[Rakesh Meel]

create procedure Myproc @myvar1 decimal as begin if @myvar1 is null begin error('@myvar1 is null', 16, 1); end; end;

[Ganu Sharma]

You can check your parameter is null or empty. there are various way in sql server or oracle database. declare @IP NVARCHAR(SIZE) IF(@IP IS NULL OR @IP = '') BEGIN SQL STATEMENTS. END ELSE BEGIN SQL STATEMENTS. END IF(@@ERROR > 0) SQL STATEMENTS. :) :)

[Ganu Sharma]

Hi.. check your parameter is null or not. in stored procedure if(parameter is null or parameter ='') begin sql statements end else begin sql statements end or in single query. select * from tbl where parameter is null or parameter =''