storedprocedure

Question

i have written a query in sp for update, but am getting result as the new value is appended to the old value insted of the new vale, why it happens?

Sukesh Marla · Answer

what do u mean by appended, Please explain it properly dear,then only we can help.

Akkiraju Ivaturi · Answer

Please copy the stored procedure in word and then paste it. Otherwise, the code cannot be understood.

anil john · Answer

This my sp: ALTER PROCEDURE dbo.sp_UserRights ( @iUserLevel int, @vAddUser varchar(50), @vBalance varchar(50), @vBankofAccounts varchar(50), @vBranchMaster varchar(50), @vChittyAuction varchar(50), @vChittyGeneralReciept varchar(50), @vChittyInstallments varchar(50), @vChittyMaster varchar(50), @vChittyPayments varchar(50), @vChittyReciepts varchar(50), @vChittyRegistration varchar(50), @vChittyReport varchar(50), @vCompanyMaster varchar(50), @vContra varchar(50), @vCustomerLedger varchar(50), @vCustomerMaster varchar(50), @vDueList varchar(50), @vEmployeeMaster varchar(50), @vGeneralPayments varchar(50), @vGeneralReciept varchar(50), @vInstallmentCreation varchar(50), @vJournelEntry varchar(50), @vLogin varchar(50), @vMAGNA varchar(50), @vMAGNA_BRANCH varchar(50), @vPaymentDetails varchar(50), @vPrintBankAcc varchar(50), @vPrintPandL varchar(50), @vPrintTrailBalance varchar(50), @vReportAccountLedger varchar(50), @vUserPrevilege varchar(50), @vVoucherConfiguration varchar(50), @vVoucherListView varchar(50), @blockType int, @TempID int ) AS SET NOCOUNT ON IF(@blockType=0) Begin IF EXISTS(SELECT * FROM tblUserRights WHERE iUserLevel=@iUserLevel AND TempID=@TempID) BEGIN RETURN END ELSE BEGIN INSERT INTO tblUserRights(iUserLevel,vAddUser,vBalance,vBankofAccounts,vBranchMaster,vChittyAuction,vChittyGeneralReciept, vChittyInstallments,vChittyMaster,vChittyPayments,vChittyReciepts,vChittyRegistration, vChittyReport,vCompanyMaster,vContra,vCustomerLedger,vCustomerMaster,vDueList,vEmployeeMaster, vGeneralPayments,vGeneralReciept,vInstallmentCreation,vJournelEntry,vLogin,vMAGNA,vMAGNA_BRANCH, vPaymentDetails,vPrintBankAcc,vPrintPandL,vPrintTrailBalance,vReportAccountLedger,vUserPrevilege, vVoucherConfiguration,vVoucherListView) VALUES(@iUserLevel,@vAddUser,@vBalance,@vBankofAccounts,@vBranchMaster,@vChittyAuction,@vChittyGeneralReciept, @vChittyInstallments,@vChittyMaster,@vChittyPayments,@vChittyReciepts, @vChittyRegistration,@vChittyReport,@vCompanyMaster,@vContra,@vCustomerLedger,@vCustomerMaster,@vDueList, @vEmployeeMaster,@vGeneralPayments,@vGeneralReciept,@vInstallmentCreation,@vJournelEntry,@vLogin,@vMAGNA, @vMAGNA_BRANCH,@vPaymentDetails,@vPrintBankAcc,@vPrintPandL,@vPrintTrailBalance,@vReportAccountLedger, @vUserPrevilege,@vVoucherConfiguration,@vVoucherListView) RETURN END End ELSE IF(@blockType=1) Begin UPDATE tblUserRights SET vAddUser=@vAddUser,vBalance=@vBalance,vBankofAccounts=@vBankofAccounts,vBranchMaster=@vBranchMaster, vChittyAuction=@vChittyAuction,vChittyGeneralReciept=@vChittyGeneralReciept,vChittyInstallments=@vChittyInstallments, vChittyMaster=@vChittyMaster,vChittyPayments=@vChittyPayments,vChittyReciepts=@vChittyReciepts, vChittyRegistration=@vChittyRegistration,vChittyReport=@vChittyReport,vCompanyMaster=@vCompanyMaster, vContra=@vContra,vCustomerLedger=@vCustomerLedger,vCustomerMaster=@vCustomerMaster,vDueList=@vDueList, vEmployeeMaster=@vEmployeeMaster,vGeneralPayments=@vGeneralPayments,vGeneralReciept=@vGeneralReciept, vInstallmentCreation=@vInstallmentCreation,vJournelEntry=@vJournelEntry,vLogin=@vLogin,vMAGNA=@vMAGNA, vMAGNA_BRANCH=@vMAGNA_BRANCH,vPaymentDetails=@vPaymentDetails,vPrintBankAcc=@vPrintBankAcc,vPrintPandL=@vPrintPandL, vPrintTrailBalance=@vPrintTrailBalance,vReportAccountLedger=@vReportAccountLedger,vUserPrevilege=@vUserPrevilege, vVoucherConfiguration=@vVoucherConfiguration,vVoucherListView=@vVoucherListView WHERE iUserLevel=@iUserLevel AND TempID=@TempID SELECT @TempID As RowID End RETURN

Sukesh Marla · Answer

Can you please post query here?

storedprocedure

Answers (4)