CREATE TRIGGER zpxx_insert ON [zpxx]
FOR INSERT
ASdeclare @userid varchar
select @userid=userid from insertedupdate hyqy set hyqy.zhfbtime=getdate()
where hyqy.id=@userid
FOR INSERT
ASdeclare @userid varchar
select @userid=userid from insertedupdate hyqy set hyqy.zhfbtime=getdate()
where hyqy.id=@userid
set zhfbtime=getdate()
from hyqy a join inserted b on a.id=b.userid