SQL触发器自动记录用户操作

//新增日志
ALTER TRIGGER [dbo].[OYDTRI_A11_InsertNew] ON [dbo].[A11]  FOR Insert AS  set nocount on     
declare @username as nvarchar(128)
declare @userip as nvarchar(50)   
declare @ModuleName as nvarchar(50)   
declare @Message as nvarchar(1000)   
declare @Contents as nvarchar(3800)   
declare @ResultType as nvarchar(50)
declare @LogType as nvarchar(50) 
declare @CurDatetime as nvarchar(50) 
declare @ssql as nvarchar(500)       
set @userip='0.0.0.0' 
set @ModuleName='' 
select @Message='为'+A0101+'添加家庭成员信息' from inserted
set @ResultType='INFO'
set @LogType='OperateLog' 

Select @Contents=ISNULL(OydCreateUserName,'')+'为'+A0101+'添加一条家庭成员信息', 
@username=ISNULL([OydCreateUserName],'') ,@CurDatetime=ISNULL([OydCreateTime],getdate()) from inserted  

select @ssql='INSERT INTO [OydWebNuke_zlb].[dbo].[nuke_DataLog] ([UserName],[UserIp],[ModuleName],[Message],
[Contents],[ResultType],[LogType],[BrowserInfo],[CurDatetime],[CurUrl],[RequestContents]) VALUES
('''+@username+''','''+@userip+''','''+@ModuleName+''','''+@Message+''','''+@Contents+''','''+@ResultType+''',
'''+@LogType+''',null,'''+@CurDatetime+''',null,null)'                 
exec(@ssql)
//修改日志
ALTER TRIGGER [dbo].[OYDTRI_A11_UpdateNew] ON [dbo].[A11]  FOR Update AS  set nocount on   
declare @FN as nvarchar(50)
declare @FNjc as nvarchar(50)   
declare @username as nvarchar(128)