如何将程序从一个调用到另一个

2.InsertRecordInAuditCustomerLoan数据 Hello Team,This is my one stored procedure as follow:ALTER PROCEDURE [dbo].[UpdateCustomerLoanOCR]@CUSTOMERLOANOCRID int,@UPDATEDBY int,@UPDATEDON datetimeASBEGINupdate CUSTOMERLOANOCR WITH (ROWLOCK)setprocessed = 1,UpdatedBy = @UPDATEDBY,UpdatedOn = @UPDATEDONwhere id = @CUSTOMERLOANOCRIDEndThis is my second Stored Procedure as followsCREATE PROCEDURE InsertRecordInAuditCustomerLoanData@CustomerLoanDataID INTASBEGINInsert into AUDIT_CUSTOMERLOANDATA (CUSTOMERLOANDATAID,BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID , DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI , RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 , CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE , ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY,CREATEDON,QCTOVERIFYREMARKS,ISD1,ISD2,STD1,QCPROCESSED) Select ID,BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID , DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI , RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 , CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE , ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY,CREATEDON,QCTOVERIFYREMARKS,ISD1,ISD2,STD1,QCPROCESSEDfrom CUSTOMERLOANDATA (nolock)where id = @CustomerLoanDataIDselect @CustomerLoanDataIDendthis is my third Stored ProcedureALTER PROCEDURE [dbo].[AddCustomerLoanData]@BATCHID int,@FILELOGID int,@FILENAME varchar(max),@RECORDNO int,@FIRSTNAME varchar(25),@MIDDLENAME varchar(25),@LASTNAME varchar(25),@MOTHERNAME varchar(25),@FULLADDRESS varchar(max) ,@MOBILENO varchar(15),@EMAILID varchar(50),@DOB datetime = NULL,@LOAN1INTRATE decimal(18,2),@LOAN1AMT decimal(18,2),@LOAN2INTRATE decimal(18,2),@LOAN2AMT decimal(18,2),@DATEOFEMI datetime= NULL ,@RELEASEDATE datetime= NULL,@HOUSETYPE varchar(15),@SALARY decimal(18,2),@CUSTOMERLOANOCRID int,@CUSTOMERADDR1 varchar(100),@CUSTOMERADDR2 varchar(100),@LANDMARK varchar(50),@STATE varchar(20),@CITY varchar(20),@PINCODE varchar(7),@ADDRVERIFY varchar(3),@PHOTOVERIFY varchar(3),@GENDER varchar(6),@LANDLINENO varchar(15),@MOBILENO2 varchar(15),@COMPANYNAME varchar(50),@CREATEDBY int,@CREATEDON datetime,@QCTOVERIFYREMARKS varchar(max),@ISD1 varchar(5),@ISD2 varchar(5),@STD1 varchar(5),@ID INT OUTASBEGINinsert into CUSTOMERLOANDATA (BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID , DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI , RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 , CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE , ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY, CREATEDON,QCTOVERIFYREMARKS, ISD1,ISD2,STD1) values(@BATCHID, @FILELOGID, @FILENAME, @RECORDNO, @FIRSTNAME, @MIDDLENAME, @LASTNAME, @MOTHERNAME ,@FULLADDRESS , @MOBILENO ,@EMAILID , @DOB ,@LOAN1INTRATE ,@LOAN1AMT ,@LOAN2INTRATE ,@LOAN2AMT ,@DATEOFEMI , @RELEASEDATE ,@HOUSETYPE ,@SALARY ,@CUSTOMERLOANOCRID ,@CUSTOMERADDR1 , @CUSTOMERADDR2 ,@LANDMARK ,@STATE ,@CITY ,@PINCODE, @ADDRVERIFY ,@PHOTOVERIFY,@GENDER ,@LANDLINENO ,@MOBILENO2 ,@COMPANYNAME, @CREATEDBY ,@CREATEDON,@QCTOVERIFYREMARKS, @ISD1,@ISD2,@STD1 )SET @ID = @@IDENTITY;exec UpdateCustomerLoanOCRexec InsertRecordInAuditCustomerLoanDataEndI want to call first and second Stored Procedure in Third procedure.As i call the first and second Stored Procedure in Third procedure but it gives me error the Procedure or function 'UpdateCustomerLoanOCR' expects parameter '@UPDATEDBY', which was not supplied.As there are three parameters are present in UpdateCustomerLoanOCR and one parameter is present in InsertRecordInAuditCustomerLoanData.Please kindly tell me how should i get this solve.Is this is the right way to call procedure from one to another?ThanksHarshal 解决方案 You have not provided the parameters for the following procedures1.[UpdateCustomerLoanOCR]2.InsertRecordInAuditCustomerLoanData 这篇关于如何将程序从一个调用到另一个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！