title: Error converting datatype nvarchar to int
body: <p>I am getting the error </p>
  
  <blockquote>
    <p>Error converting datatype nvarchar to int</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>ALTER procedure [dbo].[sp_rcdoc]
    @regno int,
    @appname varchar(50),
    @DOI datetime,
    @COV varchar(50),
    @validtill date,
    @imgloc varchar(500),
    @ImagNo char(20),
    @Purposecode varchar(50),
    @FLAG varchar(3)
  AS BEGIN
     IF NOT EXISTS(SELECT regno FROM tblRCDocuments WHERE regno = @regno)
     BEGIN
         INSERT INTO tblRCDocuments(regno, appname, DOI, COV, validtill, imgloc, ImagNo, Purposecode, FLAG) 
         VALUES(@regno, @appname, @DOI, @COV, @validtill, @imgloc, @ImagNo, @Purposecode, @FLAG)
     END
  </code></pre>