Stored procedure not getting executed

See more:

SQL

Parameter

stored-procedure

Hi,

I have a stored procedure as given below:

Create Procedure ProcName(@transname varchar(200),@transno varchar(200))
As
BEGIN
set nocount on 
select tb1.pono,tb2.billno from table1 tb1
inner join table2 tb2 on tb1.id=tb2.id
where @transname=@transno
set nocount off
END

When I execute this I dont get any output.

But if I remove one parameter @transname and alter the procedure as below, I get the output.

Create Procedure ProcName(@transno varchar(200))
As
BEGIN
set nocount on 
select tb1.pono,tb2.billno from table1 tb1
inner join table2 tb2 on tb1.id=tb2.id
where pono=@transno
set nocount off
END

Actually, I want the user to pass the parameter @transname and execute the query. Please help me achieve that. What am I missing here? or what mistake I have done?