Dynamic HTML Page creation & Search through Free Text and Meta Tags of HTML by Using Index Server

��/****** Object:  Stored Procedure dbo.usp_Profile_Save    Script Date: 8/6/2003 9:52:30 AM ******/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_Profile_Save]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[usp_Profile_Save]

GO



SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



/****** Object:  Stored Procedure dbo.usp_Profile_Save    Script Date: 8/6/2003 9:52:31 AM ******/





CREATE  PROCEDURE usp_Profile_Save

-- Parameters of usp_Profile_Save

      

	@P_strName varchar(50),

	@P_strEmail varchar(50),

	@P_strPhone varchar(50),

	@P_strHomeLocation varchar(50),

	@P_bWillingToRelocate varchar(50),

	@P_strMaximumCommute varchar(50),

        @P_bIsEmployeed varchar(50),

	@P_strJobTitle varchar(50),

	@P_strExperience varchar(50),

	@P_bSecurityClearenceRequired varchar(50),

	@P_strHighestDegree varchar(50),

	@P_strSpokenLanugage varchar(50),

	@P_strCertifications varchar(50),

	@P_strDesiredJobType varchar(50),

	@P_strDesiredPay varchar(50),

	@P_strShiftPreference varchar(50),

	@P_strInterest varchar(200),

	@P_strSummary varchar(500),

	@P_nUserId INT,

        @P_OUT_nProfileId INT OUTPUT



/****************************************************************************

*Procedure Name : usp_Profile_Save

*

*Auther: Syed Adnan Ahmed  on 07/22/2003

*

*____________________________________________________________________________

*Param Name			Type	      	Length

*____________________________________________________________________________

	-- Parameters of usp_Profile_Save



        @P_strName                    varchar(50)

	@P_strEmail                   varchar(50)

	@P_strPhone                   varchar(50)

	@P_strHomeLocation            varchar(50)

	@P_bWillingToRelocate         varchar(50)

	@P_strMaximumCommute          varchar(50)

        @P_bIsEmployeed               varchar(50)

	@P_strJobTitle                varchar(50)

	@P_strExperience              varchar(50)

	@P_bSecurityClearenceRequired varchar(50)

	@P_strHighestDegree           varchar(50)

	@P_strSpokenLanugage          varchar(50)

	@P_strCertifications          varchar(50)

	@P_strDesiredJobType          varchar(50)

	@P_strDesiredPay              varchar(50)

	@P_strShiftPreference         varchar(50)

	@P_strInterest                varchar(200)

	@P_strSummary                 varchar(500)

	@P_nUserId                    INT

*

*

*____________________________________________________________________________

*

*Note:

*

*Tables Accessed:  tblProfile

*

*Stored Procedure Accessed: -None-

*

*Temp tables created and used:	-None-

*

*Reture Value: -None-

*

*Any Special Notes: 

*

*Revision#1    

*

*

***************************************************************************/

AS

 SET NOCOUNT ON



	INSERT INTO tblProfile

	VALUES (

	@P_strName,

	@P_strEmail,

	@P_strPhone ,

	@P_strHomeLocation,

	@P_bWillingToRelocate,

	@P_strMaximumCommute ,

        @P_bIsEmployeed ,

	@P_strJobTitle ,

	@P_strExperience,

	@P_bSecurityClearenceRequired,

	@P_strHighestDegree,

	@P_strSpokenLanugage,

	@P_strCertifications ,

	@P_strDesiredJobType,

	@P_strDesiredPay ,

	@P_strShiftPreference,

	@P_strInterest ,

	@P_strSummary ,

	@P_nUserId 

	)



SET @P_OUT_nProfileId = @@IDENTITY

RETURN @P_OUT_nProfileId





GO



SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO