34,837
社区成员




create trigger t_tab on a
FOR insert
as
begin
Update a set flag=isnull(char(ascii((select max(Flag) from a where Id<i.Id))+1),'A')
from inserted i,a
where i.id=a.id
end
create trigger t_tab on a
INSTEAD OF insert
as
begin
insert into a select id,flag=case postdate when '2008-8-8' then 'B' when '2008-3-1' then 'A' END,postdate from inserted
end