Create a Stored Procedure For Updating The Record

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER proc [dbo].[Update_Ind_UsedCarLoan]
(@pApplicationId int,
@pVehicleName varchar(50),
@pVehicleNumber varchar(50),
@pYearOfManufacture varchar(50),
@pTenure1  varchar(50),
@pRateOfInterest  varchar(50),
@pLoadingAmount  varchar(50),
@pExistingHypothecatedTo varchar(50),
@pExistingLoanOutstanding varchar(50),@pNotepad varchar(max)
)
as
begin
update Individual_UsedCarLoan set  VehicleName=@pVehicleName,
 VehicleNumber=@pVehicleNumber,
 YearOfManufacture=@pYearOfManufacture,
   Tenure1=@pTenure1 ,
 RateOfInterest =@pRateOfInterest,
 LoadingAmount =@pLoadingAmount,
 ExistingHypothecatedTo=@pExistingHypothecatedTo,
 ExistingLoanOutstanding=@pExistingLoanOutstanding,Notepad=@pNotepad  where ApplicationId=@pApplicationId
end