ASP.NET with C# and SQL SERVER , some vb.net . asp.net examples, asp.net codes, asp.net programs, c# code, sql server queries, important codes.
Monday, 3 December 2012
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment