Контроль изменений записей в базе данных

CREATE TABLE FunctionOfLines
(FunctionOfLines_ID INT PRIMARY KEY IDENTITY,
FunctionOfLines_Name VARCHAR(50));
 
CREATE TABLE FunctionOfLines_Log
(FunctionOfLines_Log_ID INT PRIMARY KEY IDENTITY,
FunctionOfLines_ID INT,
FunctionOfLines_Name VARCHAR(50),
LogDateTime datetime, 
LogUser VARCHAR(50), 
LogComp VARCHAR(50),
IsDeleted bit);
 
CREATE TRIGGER trg_FunctionOfLines_Edit
ON FunctionOfLines
FOR INSERT, UPDATE
AS 
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for trigger here
 
    DECLARE @tmpDate datetime
    DECLARE @UserName VARCHAR(50)
    DECLARE @MashineName VARCHAR(50)
 
    SET  @tmpDate=GetDate() 
    SET  @UserName=system_user 
    SET  @MashineName=host_name()
 
    INSERT INTO FunctionOfLines_Log ( FunctionOfLines_ID, FunctionOfLines_Name,
                            LogDateTime, LogUser, LogComp, IsDeleted )
           SELECT  FunctionOfLines_ID, FunctionOfLines_Name,
                             @tmpDate, @UserName, @MashineName,0
           FROM  inserted
 
END;
 
CREATE TRIGGER trg_FunctionOfLines_Delete
ON FunctionOfLines
FOR DELETE
AS 
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for trigger here
 
    DECLARE @tmpDate datetime
    DECLARE @UserName VARCHAR(50)
    DECLARE @MashineName VARCHAR(50)
 
    SET  @tmpDate=GetDate() 
    SET  @UserName=system_user 
    SET  @MashineName=host_name()
 
    INSERT INTO FunctionOfLines_Log ( FunctionOfLines_ID, FunctionOfLines_Name,
                            LogDateTime, LogUser, LogComp, IsDeleted )
           SELECT  FunctionOfLines_ID, FunctionOfLines_Name,
                             @tmpDate, @UserName, @MashineName,1
           FROM  deleted
       
END;