参考:
create table A
(
T_name varchar(10)
)create table B
(
T_name varchar(10)
)create proc insert_B(@T_name varchar(10))
as
insert B select @T_name
CREATE TRIGGER TEMP_SC on A
AFTER Insert
as
Declare T_sc cursor for Select T_name from inserted
Declare @T_name varchar(10)
open T_sc
fetch next from T_sc into @T_name
while @@FETCH_STATUS=0
begin
exec insert_B @T_name
fetch next from T_sc into @T_name
end
close T_sc
deallocate T_sc
insert A select 'SC'select * from Aselect * from B
create table A
(
T_name varchar(10)
)create table B
(
T_name varchar(10)
)create proc insert_B(@T_name varchar(10))
as
insert B select @T_name
CREATE TRIGGER TEMP_SC on A
AFTER Insert
as
Declare T_sc cursor for Select T_name from inserted
Declare @T_name varchar(10)
open T_sc
fetch next from T_sc into @T_name
while @@FETCH_STATUS=0
begin
exec insert_B @T_name
fetch next from T_sc into @T_name
end
close T_sc
deallocate T_sc
insert A select 'SC'select * from Aselect * from B
----怎么能修改过程的局部变量呢
只可给过程传参exec proc_test @T_name