;with Args as ( select * from Taba where charindex(','+rtrim(pid),',' + @para1,1) > 0 union all select * from Taba ,Args where Taba .id = Args.pid ) select id = ',' + rtrim(id) from Args ;
create proc proc_test @para1 varchar(8000) = null as begin ;with Args as ( select * from Taba where charindex(','+rtrim(pid),',' + @para1,1) > 0 union all select * from Taba ,Args where Taba .id = Args.pid ) select id = ',' + rtrim(id) from Args ; end
(
select * from Taba where charindex(','+rtrim(pid),',' + @para1,1) > 0
union all
select * from Taba ,Args
where Taba .id = Args.pid
)
select id = ',' + rtrim(id) from Args ;
create proc proc_test
@para1 varchar(8000) = null
as
begin
;with Args as ( select * from Taba where charindex(','+rtrim(pid),',' + @para1,1) > 0 union all select * from Taba ,Args where Taba .id = Args.pid ) select id = ',' + rtrim(id) from Args ;
end
黑木崖上的蜗牛万分感谢你。谢谢!!!!