Create a Stored Procedure For Inserting a Record

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER proc [dbo].[Insert_Ind_Homeloan]
(
@pApplicationId int,
@pValuationAmount varchar(50),
@pLoanAmount varchar(50) ,
@pSuraksha  varchar(50),
@pPropertyInsurance varchar(50) ,
@pOthers  varchar(50),
@pTotalLoanAmount  varchar(50),
@pProccesingFee  varchar(50),
@pStampDuty  varchar(50),
@pSurakshaDeduction  varchar(50),
@pPropertyInsuranceDeduction  varchar(50),
@pValuationFee  varchar(50),
@pLegalFee  varchar(50),
@pNetLoanAmount  varchar(50),
@pLoanAmountDetails  varchar(50),
@pTenure  varchar(50),
@pEmiAmount  varchar(50),
@pEmi  varchar(50),
@pRateOfInterest  varchar(50),
@pLoadingAmount  varchar(50),
@pExistingHypothecatedTo  varchar(50),
@pExistingLoanOutstanding varchar(50),
@pNotepad varchar(max)
)
as
begin
insert into Individual_HomeLoan values(@pApplicationId,
@pValuationAmount,
@pLoanAmount,
@pSuraksha,
@pPropertyInsurance,
@pOthers,
@pTotalLoanAmount,
@pProccesingFee,
@pStampDuty,
@pSurakshaDeduction,
@pPropertyInsuranceDeduction,
@pValuationFee,
@pLegalFee,
@pNetLoanAmount,
@pLoanAmountDetails,
@pTenure,
@pEmiAmount,
@pEmi,
@pRateOfInterest,
@pLoadingAmount,
@pExistingHypothecatedTo,
@pExistingLoanOutstanding,
@pNotepad

)
end