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