触发器求解 急100分在线等 好用立即给分!
fchxx 2003-10-24 03:56:05 create trigger my_trigger on testtab
after insert as declare @pub_name varchar(50)
declare pub_crsr cursor for select top 1 v_name from testtab
open pub_crsr
fetch next from pub_crsr into @pub_name
insert into test (v_name) values(@pub_name)
close pub_crsr
deallocate pub_crsr
执行后死循环!请指教!多谢!!!