Stored procedure..

Question

I'm using If Condition Srore procedure...

But .. I need if stored procedure with where in if else condition and concatenate with to and condition in Query..

Examble

create procedure [dbo].[Sp_Name]
    @code int,
    @dCode int  
As
select <.........> from  <tablename>
Where empcode=@code 
if (@dCode != 0)
Begin
    And dptcode=@ dCode 
End

Please help me find a solution...

Answer 1

Would this work for you:

create procedure [dbo].[Sp_Name]
    @code int,
    @dCode int          
As
    select <.........> from  <tablename>
    Where empcode=@code AND (@dCode = 0 OR dptcode=@dCode)

Your question is pretty hard to understand - this is what I guess from what I actually did understand.

Answer 2

create procedure [dbo].[Sp_Name]
    @code int,
    @dCode int          
As
select <.........> from  <tablename>
Where empcode=@code 
if (@dCode != 0)
Begin
    Select dptcode=@dCode 
End

Not sure if that's what the poster was after, can some one please edit the text and correct it.