トリガー:削除時にトリガーして情報を記録する

-- delete 

CREATE TRIGGER trig_delete_mzy_request
   ON mzy_request　　-- 
   for delete
AS 
BEGIN

    DECLARE @IP_Address varchar(50)=''; 

    SELECT TOP 1 @IP_Address=client_net_address -- IP 
    FROM sys.dm_exec_connections  
    WHERE session_id = @@SPID; 
  --  
  insert into mzy_request_delete_log select *,GETDATE() as DeleteTime,@IP_Address AS IpAddress from Deleted;  

END