alter TRIGGER Updt ON Seorder
FOR UPDATE,INSERT
AS
set nocount on
----declare @gb smallint 这两句不要的吧!
----set @gb= fclosed from inserted
if(update(fclosed))
BEGIN
update seorder set fheadselfs0152=(select getdate()) from seorder a join inserted b on a.finterid=b.finterid
END