sqlserver怎么用触发器写入删除日志？

sqlserver2008里面怎么编写一个触发器，实现表1删除用户的时候，往表2里面写入一条删除日志记录？请各位小伙伴帮忙看一下。

log表

CREATE TABLE [dbo].[LOGR](
    [USERID] [varchar](50) NULL,
    [STRSQL] [varchar](max) NULL,
    [DATE] [varchar](8) NULL,
    [TIME] [varchar](8) NULL,
    [TABLNM] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

触发器

CREATE TRIGGER [dbo].[KNMT_LOG] ON [dbo].[PATIENT] 
FOR DELETE 
AS
 
DECLARE @CLIENT AS VARCHAR(50)
DECLARE @DATE AS VARCHAR(8)
DECLARE @TIME AS VARCHAR(8)
DECLARE @USERNAME AS VARCHAR(50)
DECLARE @STATMT  AS VARCHAR(max)
DECLARE @strSQL AS VARCHAR(100)
 
SET @CLIENT = HOST_NAME()
SET @DATE = CONVERT(VARCHAR(8),GETDATE(),112)
SET @TIME =REPLACE(CONVERT(VARCHAR(8),GETDATE(),108),':','')
SET @strSQL='DBCC INPUTBUFFER('+CAST(@@SPID AS VARCHAR(50))+')'
 
CREATE TABLE #STATEMENT (C1 VARCHAR(50),C2 VARCHAR(50),C3 VARCHAR(5000))
INSERT INTO #STATEMENT  EXEC(@strSQL)
 
SELECT @STATMT=C3 FROM #STATEMENT
 
INSERT INTO LOGR(USERID,STRSQL,DATE,TIME,TABLNM) VALUES(@CLIENT,@STATMT,@DATE,@TIME,'PATIENT')