create trigger t_update on 表
for update
as
declare tb cursor for select type from inserted
declare @type varchar(50)
open tb
fetch next from tb into @type
while @@fetch_status=0
begin
exec 要调用的存储过程 @type
fetch next from tb into @type
end
close tb
deallocate tb
go
declare cursor_insert cursor for select Type from 通用信息表
declare @i varchar(100)
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec 调用一个存储过程 @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert