CREATE PROCEDURE dbo.uspCompanyR equirement
(
@sCompanyName varchar(80),
@sJobCode varchar(10),
@sQualification varchar(20),
@sExperience varchar(5),
@iExpYrs int,
@sSkillset varchar(20),
@sSalary varchar,
@sInterviewDate varchar(10),
@sLocation varchar(80)
)
AS begin
insert into dbo.CompanyRequ irements values(@sCompan yName,@sJobCode ,@sQualificatio n,@sExperience,
@sExpYrs,@sSkil lset,@sSalary,@ sInterviewDate, @sLocation)
end
(
@sCompanyName varchar(80),
@sJobCode varchar(10),
@sQualification varchar(20),
@sExperience varchar(5),
@iExpYrs int,
@sSkillset varchar(20),
@sSalary varchar,
@sInterviewDate varchar(10),
@sLocation varchar(80)
)
AS begin
insert into dbo.CompanyRequ irements values(@sCompan yName,@sJobCode ,@sQualificatio n,@sExperience,
@sExpYrs,@sSkil lset,@sSalary,@ sInterviewDate, @sLocation)
end
Comment