title: Insert multiple records using stored procedure
body: <p>I have two tables </p>
  
  <pre><code>emplyoee (first table)
  id primary key auto increment
  emp_name varchar
  
  student(second table)
  id foriegnkey emplyoee.id
  st_name varchar
  </code></pre>
  
  <p>I want to insert multiple student records for a single <code>employeeid</code> . My code is attached here , but this use to only one student record update. How can I write stored procedure for this need.
  I am new with SQL server and stored procedure.</p>
  
  <p>Could you please help me?</p>
  
  <pre><code>create procedure  empst_Sp
  @emp_name varchar(50),
  @st_name varchar(50)
  as
  begin
  insert into emplyoee (emp_name) values (@emp_name)
  insert into student(id,st_name) values(SCOPE_IDENTITY(),@st_name)
  end
  </code></pre>