

create trigger insert_trigger
on ResolveItem
for insert as
Declare @DescribeID int
select @DescribeID=DescribeID from inserted
begin
update Describe set DescribeState=1 where OID=@DescribeID
end
转载于:https://www.cnblogs.com/renjuwht/archive/2009/07/14/1523200.html