Multiple conditions to be check in stored procedure

Question

I need to check the Multiple conditions to be check in stored procedure if travel condition is true then return the travel details if not other condition ................ ................... like wise i need to check the conditions in stored procedure can you please show one demo please help me this

Rupesh Kahane · Answer

Create Procedure GetDetails( --Declare @TravelId INT = 0 ) AS Begin if OBJECT_ID( 'tempdb..#my_travel' ) is not null Begin Drop Table #my_travel End CREATE TABLE #my_travel ( travelId int , travelCity varchar (100) ) Insert Into #my_travel values (1, 'Pune' ) Insert Into #my_travel values (2, 'Mumbai' ) Insert Into #my_travel values (3, 'Delhi' ) if(@TravelId= 1) BEGIN Select * from #my_travel where travelId = @TravelId END ELSE IF @TravelId = 2 BEGIN Select * from #my_travel where travelId = @TravelId END ELSE IF @TravelId = 3 BEGIN Select * from #my_travel where travelId = @TravelId END End Please refer above store procedure. I have created small temp table to get travel details.If you aare passing parameters to that procedure then it will check the id and on that basis I have added If conditions so you will get result you have to execute procedures as like exec GetDetails 1 All the best. Let me know if you have any queries.

Sanwar Ranwa · Answer

Hello We chcek mutliple conditions is store proc lets see some example of create proc checkpwd ( @name varchar(50),@pwd varchar(50)) as begin if exists(select * from login where name=@name and pwd=@pwd) begin select 'Name and Password already exits' end else insert into login values(@name,@pwd) end end this proc is used to check single conditons lets check some more example ALTER procedure [dbo].[Proc_CheckUser] @userid VARCHAR(50), @password VARCHAR(50) AS SET nocount ON DECLARE @ReturnVal VARCHAR(500) DECLARE @PasswordOld VARCHAR(50) SELECT @PasswordOld = password FROM Clients WHERE username = @userid IF ( @PasswordOld IS NULL ) SET @ReturnVal='1|Incorrect Username' ELSE IF ( @PasswordOld = Hashbytes('SHA1', @password) ) SET @ReturnVal='0|Logged in Successfully' ELSE SET @ReturnVal='2|Incorrect Password' SELECT @ReturnVal We can check more condition in a proc

Multiple conditions to be check in stored procedure

Answers (2)