1、触发器详解
2、如何修改触发器
3、
查询当前数据库中所有触发器
SELECT * FROM Sysobjects WHERE xtype = 'TR'
我的触发器
create Trigger PBalanceChange
On Account
for Update
as
if Update(PBalance)
begin
insert into Account_Change ([uid],uname,num) select A.[UID],A.UName,i.PBalance-d.Pbalance from deleted d,Inserted i ,Account A where a.[Uid]=i.[uid] and i.[uid]=d.[uid]
end