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
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
where @transname=@transno
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)