how to use the if-else condition in storedprocedure

Mahesh Babu

8y801Learn iOS Programming

My Requirement is:

I need to check

1.if Empid is Null or not?

If it is Null I need to display the message

2, if Empid exist or not in the table

if Empid exists I need to display the record

3. If FinancialYear is is Null or not?

4. if financial year exist or not in the table

5. Based on the Empid I need to get the FinancialYear

6.After getting the financial year If the financial year is existed or not in the table

Below u can find the code

pLease help me this

ALTER PROCEDURE [dbo].[SPBudget]

@empID varchar(50),

@financialYear varchar(50),

@cost varchar(50)

BEGIN

Declare @records varchar(max)

Declare @Financial varchar(max)

Declare @Cost varchar(max)

IF ISNULL(@empId,0)!=0

BEGIN

if(select Count([Num]) from [Employee] where [Num]=@empId)<=0

set @records='empid doesnot exist'

select @records as [EmpID]

END

IF ISNULL(@financialYear,0)!=0

BEGIN

if(select Count( [FinancialYear]) from [Expense] where [FinancialYear]=@financialYear)<=0

set @Financial='Year doesnot exist'

select @Financial as [FinancialYear]

END

IF(@cost!=0)

BEGIN

if(select Count( [Cost]) from [Employee] where [Cost]=(select [Cost] from [Employee] where [Num]=@empId))<=0

if(@cost=@empId)

begin

select * from [Employee]

END

Else

begin

set @Cost ='cost doesnot exist'

end

END

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gaurav Raj8y ago
select * ,case when l.id=@UserId then (''if condition follow condition then print msg') else ('if not follow condition then print msg') end as LIKED
from table_Name

you can use like this
Mahesh Babu8y ago
not displaying the message

I need to store in a variable n display the message

I need to check the condition if Empid null or not

please help me this
Rafnas T P8y ago
hi,
try below code
ALTER PROCEDURE [dbo].[SPBudget]
(
@empID varchar(50)=null,
@financialYear varchar(50)=null,
@cost varchar(50)=null
)
AS
BEGIN
Declare @records varchar(max)
Declare @Financial varchar(max)
Declare @Cost varchar(max)

if(select Count([Num]) from [Employee] where [Num]=@empId)<=0
Begin
set @records= 'empid doesnot exist'
select   @records
END
else IF ISNULL(@financialYear,0)!=0
BEGIN
if(select Count( [Num]) from [Expense] where [FinancialYear]=@financialYear and [Num]=@empId)<=0
begin
set @Financial='Year doesnot exist'
select @Financial
END
else if(select Count( [Num]) from [Employee] where  where [FinancialYear]=@financialYear and [Num]=@empId and Cost=@cost)<=0
begin
set @Cost= 'cost doesnot exist'
select  @Cost
end
else
begin
select * from [Employee]
END

END