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] [varchar](50) 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
)
storedprocedure as---
CREATE PROCEDURE JSP_ResumeUpdate
@JS_Id [int],
@UserEmailId [varchar](150),
@Name [varchar](50),
@Phone [varchar](200) ,
@Institute [varchar](100) ,
@Batch varchar(50),
@Designation varchar(100),
@Organization varchar(100) ,
@Experience_Months varchar(10),
@Experience_Years varchar(10) ,
@TotalExp int ,
@Industry varchar(300),
@CurrentLocation varchar(100) ,
@PreferredLocation varchar(100) ,
@IsInserted int ,
@IsUpdated int ,
@Result Tinyint OutPut
AS
BEGIN
IF EXISTS(SELECT * FROM JS_ResumeInsert WHERE UserEmailId =@UserEmailId )
BEGIN
SET @Result = 0
END
ELSE
BEGIN
UPDATE JS_ResumeInsert SET
JS_Id=@JS_Id ,
UserEmailId=@UserEmailId ,
Name=@Name ,
Phone=@Phone ,
Institute=@Institute ,
Batch=@Batch ,
Designation=@Designation ,
Organization=@Organization ,
Experience_Months=@Experience_Months,
Experience_Years=@Experience_Years ,
TotalExp=@TotalExp ,
Industry=@Industry ,
CurrentLocation=@CurrentLocation ,
PreferredLocation=@PreferredLocation ,
IsInserted=@IsInserted ,
IsUpdated=@IsUpdated ,
CreationDate=GETDATE()
set @Result =1
return
END
END