触发器的例子

create trigger OrderAds on  HR_Ads
for insert
as
begin
declare @OrderId int
select @OrderId=isnull(max(Order_ID),0)+1 from [HR_Ads]
update HR_Ads set Order_ID =@OrderId where Gid=(Select Gid from Inserted)
--select * from inserted
end