22,210
社区成员
发帖
与我相关
我的任务
分享
----存储过程2,获取存储过程pro_aaa的结果集,
alter procedure pro_bb
as
begin
declare @billid varchar(200)
create table #tab_content(
billid varchar(800)
)
insert into #tab_content(billid)
exec pro_aaa 'tests'
select * from permit_msg where billid in (select billid from #tab_content )
end
go
----存储过程pro_aaa,获取满足条件的billid即主键ID
alter procedure pro_aaa
@content varchar(500) ,
@billid varchar(500) out
as
begin
declare @msg_billid varchar(200)
create table #tab_content(
billid varchar(800)
)
set nocount on
insert #tab_content
exec ('select billid from permit_msg where content like ''%'+@content+'%''' )
set nocount off
select @billid=isnull(@billid+',','')+ltrim(billid)
from permit_msg
where billid in (select billid from #tab_content)
end
go
----存储过程2,获取存储过程pro_aaa的结果集,
alter procedure pro_bb
as
begin
declare @billid varchar(200)
exec pro_aaa 'tests',@billid out
exec('select * from permit_msg where billid in ('+@billid+')')
end
go