--插入触发器
ALTER TRIGGER [dbo].[Trg_into_fiPayableMoney]
on [dbo].[fiPayableMoney]
for insert
as
BEGIN
DECLARE @sCreator VARCHAR(50),@uGUID VARCHAR(50)
SELECT @sCreator =dbo.GetEnumName('USER',sCreator) ,@uGUID=uGUID FROM inserted;
UPDATE fiPayableMoney SET sMoneyNo=sMoneyNo+'('+@sCreator+')' where @uGUID=uGUID
end