过程或函数'UpdateRegistration'需要参数'@CreatedBy'，这是未提供的。 [英] Procedure or function 'UpdateRegistration' expects parameter '@CreatedBy', which was not supplied.

问题描述

您好我正在设计Web应用程序我在执行时遇到此错误。请帮我解决这个问题。下面的代码是存储过程。

Hi I am designing web application I am getting this error while executing. please help me to fix this. Below code is the stored procedure.

ALTER PROCEDURE [dbo].[UpdateRegistration]( 
    @Title nvarchar(500)
    ,@CounterParty nvarchar(200) 
    ,@Company nvarchar(10)
    ,@Custodian  varchar(25)
    ,@OwnerDepartment  varchar(100)
    ,@Remarks  nvarchar(1000)
    ,@Status  varchar(2)
    ,@SecurityLevel  varchar(2)
    ,@CreatedBy  varchar(25)
    ,@CreatedOn datetime
    )
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here

        INSERT INTO dbo.Registration
                (Title
                ,Counterparty
                ,Company
                ,Custodian
                ,OwnerDepartment
                ,Remarks
                ,Status
                ,SecurityLevel
                ,CreatedBy
                ,CreatedOn)

    VALUES
    (            @Title
                ,@Counterparty
                ,@Company
                ,@Custodian
                ,@OwnerDepartment
                ,@Remarks
                ,@Status
                ,@SecurityLevel
                ,@CreatedBy
                ,@CreatedOn
                )
        END

推荐答案

你需要通过执行存储过程时参数'@CreatedBy'的值。

You need to pass value for parameter '@CreatedBy' when you are executing store procedure.

这篇关于过程或函数'UpdateRegistration'需要参数'@CreatedBy'，这是未提供的。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！