trigger sql server

Êý¾Ý¿â±íÖеÄtrigger ¿ÉÒÔ×Ô¶¯Éú³ÉÂð
»¹ÊÇÐèÒªÊÖд
trigger ×÷ÓÃÊÇʲô

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER TRIGGER [dbo].[tr_i_AUDIT_ADDRESS_INFORMATION]
ON [dbo].[ADDRESS_INFORMATION]
FOR INSERT
NOT FOR REPLICATION
As
-- " <TAG>SQLAUDIT GENERATED - DO NOT REMOVE </TAG>"
-- -------------------------------------------------------------------------------------
BEGIN
DECLARE
@IDENTITY_SAVE varchar(50),
@AUDIT_LOG_TRANSACTION_ID Int,
@PRIM_KEY nvarchar(4000),
--@TABLE_NAME nvarchar(4000),
@ROWS_COUNT int

SET NOCOUNT ON

--Set @TABLE_NAME = '[dbo].[ADDRESS_INFORMATION]'
Select @ROWS_COUNT=count(*) from inserted
Set @IDENTITY_SAVE = CAST(IsNull(@@IDENTITY,1) AS varchar(50))

INSERT
INTO dbo.AUDIT_LOG_TRANSACTIONS
(
TABLE_NAME,
TABLE_SCHEMA,
AUDIT_ACTION_ID,
HOST_NAME,
APP_NAME,
MODIFIED_BY,
MODIFIED_DATE,
AFFECTED_ROWS,
[DATABASE]
)
values(
'ADDRESS_INFORMATION',
'dbo',
2, -- ACTION ID For INSERT
CASE
  WHEN LEN(HOST_NAME()) < 1 THEN ' '
  ELSE HOST_NAME()
END,
CASE
&nbs