Stored procedure: must declare the scalar variable

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ransaj
    New Member
    • Mar 2010
    • 3

    Stored procedure: must declare the scalar variable

    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
    Last edited by ransaj; Mar 30 '10, 07:20 PM. Reason: must declare scalar variable "@iExpYrs"
  • ransaj
    New Member
    • Mar 2010
    • 3

    #2
    done.....the problem is solved now

    Comment

    • Frinavale
      Recognized Expert Expert
      • Oct 2006
      • 9749

      #3
      What was the cause of the problem and how did you fix it?

      Comment

      Working...