存储过程可以一次删掉多个数据吗?
我有两张表table1、table2.
在table1 中建立一个触发器:trg_delete
每次删除table1 中的用户时同时删除table2 中的用户。可是table2中用户删除时
会关联多个表,我有调用了事务。
我的触发器如下:
create trgDelete
on table1
for delete
as
declare @name varchar(30)
declrea @ID int
select @name =name from deleted
if exists(select ID from table2 where name =@name)
begin
select @ID =ID from table2 where name =@name
execute prcDelete @ID
end
return
我的存储过程是:
create procedure prcDelete
@ID int
as
begin transaction trnDelete
update message set ID =null where ID @ID
delete from group where ID =@ID
delete from table2 where ID =@ID
commit transaction trnDelete
return
可是上面的语句在删除多个数据时,table2中的数据只删除一个,请问要同时删除多个数据该怎么做?求大侠出手!多谢多谢!