sp_executesql

ALTER procedure [dbo].[EditChallanEntry]
 @ChlLink int,
 @BankCode char(30),
--@DDOCode char(30),
@MajorHead char(30),
@BudgetHead char(30),
--@Transtype int,
--@RemitterName char(30),
@DivisionHead char(30),
@Amount decimal,
@Commission decimal
 as
DECLARE @sql NVARCHAR(3000)
DECLARE @paradef NVARCHAR(3000)
--DECLARE @challanno  int
Begin
set @sql='Update Challan set BankBranchCode= @BankCode,MajorHead=@MajorHead,BudgetHead=@BudgetHead,DivCode=@DivisionHead,TotalAmt= @Amount,Commission=@Commission where convert(varchar(25),SUBSTRING(BudgetHead,10,4)+Convert(varchar(5),chlLink))= @ChlLink'
set @paradef=N'@ChlLink int,@BankCode char(30),@MajorHead char(30),@BudgetHead char(30),@Amount decimal,@Commission decimal,@DivisionHead char(30)'
execute sp_executesql @sql,@paradef,@ChlLink,@BankCode,@MajorHead,@BudgetHead,@Amount,@Commission,@DivisionHead
--select @sql
end