Hi
I have 2 tables
ex: TableStudent(studentID,Name, School, Country), TableDeletedRec(ID,studentID,Name,Administrator)
Now all i want to do is create store procedure to delete student record from TableStudent and save studentID,Name from TableStudent to TableDeletedRec before record deleted and additionally i want to pass the value for Administrator