USE  MIODB
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
CREATE TRIGGER [dbo].Ordini_DELETE   ON  [dbo].Ordini  AFTER delete
AS 
BEGIN 
    insert into dbo.OrdiniDelete([TIPO] ,[ID_ORD] ,[Numero] ,[Data]) VALUES ('ORDINE',  DELETED.ID_Ordine, DELETED.DocNum, GETDATE() )
END
GO