title: Can't insert a second row into a table though it insert first row by stored procedure
body: <p>It inserted a first row successfully but it's not inserting any other row, though second row has no conflict of primary key   </p>
  
  <p>Code in my <code>aspx.cs</code> file:</p>
  
  <pre><code> outputParVal = sqlCmd.Parameters[outputParName].Value; 
  </code></pre>
  
  <p><code>outparameter</code> in stored procedure is--- "Result" </p>
  
  <pre><code>CREATE PROCEDURE [dbo].[RecruiterProfileInsert]  
    @CompanyId int,     
    @CompanyName varchar(200),    
    @EmailId   varchar(50) ,    
    @Password  varchar(20) ,    
    @ContactNumber varchar(15),    
    @Website  varchar(50),    
    @CompanyProfile varchar(2000),   
    @IsVerified bit,   
    @Result Tinyint OutPut  
    --@CreatedDate  datetime ,    
    --UpdatedDate datetime         
  AS  
  BEGIN        
      -- Insert statements for procedure here          
   --check whether @CompanyName already exist or not if exist then return           
  IF EXISTS(SELECT Top 1 * FROM  RecruiterProfile WHERE @CompanyId = LTRIM(RTRIM(@CompanyId)))        
   BEGIN          
    SET @Result = 0-- Already Exists          
   END          
  ELSE          
  BEGIN              
   INSERT INTO RecruiterProfile        
  (    
    CompanyId,    
    CompanyName,    
    EmailId ,    
    Password ,    
    ContactNumber,    
    Website ,    
    CompanyProfile ,  
    IsVerified,    
    CreatedDate    
  )        
   VALUES        
  (    
  @CompanyId,    
  @CompanyName,        
  @EmailId ,         
  @Password,      
  @ContactNumber,          
  @Website,       
  @CompanyProfile,  
  @IsVerified,          
  GetDate()  
  )        
  set @Result =1     
   return                
   END   
  END         
  </code></pre>