改存储过程pro2:
CREATE procedure pro2
@param1 varchar(100),@param2 varchar(100)
as
create table #t(xhbh varchar(20))
insert into #t(xhbh) exec pro1 参数1,参数2
delete from bd_sbsxbjg where cjbh=(select cjbh from bd_zzcj where cjmc=@param1)
and xxflbh in(select xhbh from #t)
drop table #t
CREATE procedure pro2
@param1 varchar(100),@param2 varchar(100)
as
create table #t(xhbh varchar(20))
insert into #t(xhbh) exec pro1 参数1,参数2
delete from bd_sbsxbjg where cjbh=(select cjbh from bd_zzcj where cjmc=@param1)
and xxflbh in(select xhbh from #t)
drop table #t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货