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;
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