CREATE TRIGGER aa  ON [dbo].[a1] 
FOR INSERT, UPDATE, DELETE 
AS

set nocount on

--用临时表保存exec('DBCC INPUTBUFFER...')的返回值
create table #temp(EventType varchar(50),Parameters int ,EventInfo varchar(6000))
--DBCC INPUTBUFFER需要参数spid
declare @spid varchar(20)
set @spid=cast(@@spid as varchar)
insert  #temp  exec('DBCC INPUTBUFFER ('+@spid+')')

insert Test_Log(AppName,Sql,UserName,HostName,Time)
select App_Name(), --应用程序名,比较有用,你可以发现是否有用查询分析器修改数据的
EventInfo,         -- SQL语句,主要用来发现程序错误
SYSTEM_USER,       --用户名
Host_name(),       --主机名
getdate()          --发生时间
from  #temp

------解决方案--------------------

CREATE TRIGGER CKupdateItem ON [dbo].[Third_CKDetail]  
FOR INSERT
AS
IF UPDATE(iQuantity)
BEGIN
DECLARE @iQuantity INT
DECLARE @cInvID INT
SELECT @iQuantity=iQuantity FROM INSERTED
SELECT @cInvID=cInvID FROM INSERTED
UPDATE Item SET fdblSalePrice5=fdblSalePrice5-@iQuantity WHERE flngItemID=@cInvID
END