DELETE TRIGGER

CREATE TRIGGER [dbo].[Student_Update]
ON [dbo].StudMarks
AFTER DELETE
AS
BEGIN
INSERT INTO StudMarks2 SELECT Regdno,MathsMarks,StatsMarks,CompScienceMarks,TotMarks,AvgMarks FROM DELETED
END