ERROR MESSAGE-
"Procedure or function 'JSP_ResumeInsert' expects parameter '@CreationDate', which was not supplied.
"
table script as--
CREATE TABLE [dbo].[JS_ResumeInsert](
[JS_Id] [int] NULL,
[UserEmailId] [varchar](150) NULL,
[Name] [varchar](50) NULL,
[Phone] [varchar](200) NULL,
[Institute] [varchar](100) NULL,
[Batch] [int] NULL,
[Designation] [varchar](100) NULL,
[Organization] [varchar](100) NULL,
[Experience_Months] [varchar](10) NULL,
[Experience_Years] [varchar](10) NULL,
[TotalExp] [int] NULL,
[Industry] [varchar](300) NULL,
[CurrentLocation] [varchar](100) NULL,
[PreferredLocation] [varchar](100) NULL,
[IsInserted] [int] NULL,
[IsUpdated] [int] NULL,
[CreationDate] [datetime] NULL
)
CREATE PROCEDURE [dbo].
[JSP_ResumeInsert]
@JS_Id int ,
@UserEmailId varchar(150),
@Name varchar(150),
@Phone varchar(50) ,
@Institute varchar(150),
@Batch varchar(30) ,
@Designation varchar(150) ,
@Organization varchar(150),
@Experience_Months varchar(30) ,
@Experience_Years varchar(30) ,
@TotalExp varchar(50),
@Industry varchar(300) ,
@CurrentLocation varchar(100) ,
@PreferredLocation varchar(100),
@IsInserted int ,
@IsUpdated int ,
@CreationDate datetime,
@Result Tinyint OutPut
AS
BEGIN
IF EXISTS(SELECT * FROM JS_ResumeInsert WHERE UserEmailId =@UserEmailId )
BEGIN
SET @Result = 0-- Already Exists
END
ELSE
BEGIN
INSERT INTO JS_ResumeInsert
(
JS_Id ,
UserEmailId,
Name ,
Phone ,
Institute ,
Batch ,
Designation ,
Organization ,
Experience_Months ,
Experience_Years ,
TotalExp ,
Industry ,
CurrentLocation ,
PreferredLocation ,
IsInserted ,
IsUpdated ,
CreationDate
)
VALUES
(
@JS_Id,
@UserEmailId ,
@Name,
@Phone ,
@Institute ,
@Batch ,
@Designation ,
@Organization ,
@Experience_Months ,
@Experience_Years ,
@TotalExp ,
@Industry ,
@CurrentLocation ,
@PreferredLocation ,
@IsInserted ,
@IsUpdated ,
GetDate()
)
set @Result =1
return
END
END