CREATE TRIGGER [dbo].[DeleteCompany]
   ON  [dbo].[Companii] for Delete
   
AS 
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;
INSERT INTO Istorie_Op_Companii
                      (id_companie, alte_date_companie, operatie)
SELECT     Id, alte_date, 'stergere' AS Expr1
FROM         Deleted
    -- Insert statements for trigger here

END



care e faza cu cu 
SELECT     Id, alte_date, 'stergere' AS Expr1
FROM         Deleted 

mai exact acel AS Expr1 ... si din cate inteleg tabela Deleted este o tabela temporara creata cand este apelat Delete nu ?