C#技术百科
问问你的心你有没有信心 做事情要专一坚定,执着
posts - 1050,  comments - 84,  trackbacks - 3

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

 

posted on 2008-11-28 16:05 王德田 阅读(...) 评论(...) 编辑 收藏