SQL - Crear un trigger que al eliminar almacene en otra tabla

CREATE TRIGGER trgname ON mytable

AFTER DELETE

AS

BEGIN

INSERT INTO DELETEDITEMS

SELECT * FROM DELETED;

END

GO

END

begin transaction

insert into DeletedItems (fieldlist)

select fieldlist from mytable where id = @id

delete from CurrentItems where id = @id

commit transaction