title: bit Data type usage in Stored procedure
body: <p>I want to capture Radio button values in db so i created table with datatype bit
    But the problem when am create stored Procedure as</p>
  
  <pre><code>CREATE PROCEDURE Mt_Vacancy_mainPreference_insert
  
      (
      @post_name varchar(20),@preference varchar(20),gender bit,No_of_vac int
      )
  
  AS
      Begin
      insert into Mt_Vacancy_mainPreference values(@post_name, @preference, @gender, @No_of_vac)
      end
      RETURN
  </code></pre>
  
  <p>It says Incorrect Sytax near gender
  Must produce scal value
  What is the problem</p>