I need to create a Stored Procedure to Assign the students to Sections.
I have two table
1.STudent table (In this i have students details and (StudentID) is Primarykey
2.AssignStudent table.(In this table i have two Foreign Key columns (StudentID and SectionId)
In the Image If i click the forword symbol students need to get assigned
If i click the Backward symbol they need to get delete from AssignStudents Table.
How to do this ?