逆向查询所有父栏目
1
CREATE PROCEDURE c_GetAllContentByChid
2@Chid varchar(50)
3 AS
4declare @str varchar(4000)
5set @str=','+@Chid
6 while @@ROWCOUNT>0
7
8 select @str=@str+','+cast(ParentID as varchar(50)) from Tbl_ChannelInfo
9 where charindex(','+cast(Cid as varchar(50))+',',@str+',')>0
10 and charindex(','+cast(ParentID as varchar(50))+',',@str+',')=0
11
12select a.ChannelTitle,b.* from Tbl_ContentInfo as b
13inner join
14(select * from Tbl_ChannelInfo where charindex(',{'+cast(Cid as varchar(50))+'},',@str+',')>0 ) as a
15on b.ParentID=a.cid
16GO
CREATE PROCEDURE c_GetAllContentByChid2
@Chid varchar(50) 3
AS4
declare @str varchar(4000)5
set @str=','+@Chid6
while @@ROWCOUNT>07
8
select @str=@str+','+cast(ParentID as varchar(50)) from Tbl_ChannelInfo 9
where charindex(','+cast(Cid as varchar(50))+',',@str+',')>0 10
and charindex(','+cast(ParentID as varchar(50))+',',@str+',')=0 11
12
select a.ChannelTitle,b.* from Tbl_ContentInfo as b13
inner join14
(select * from Tbl_ChannelInfo where charindex(',{'+cast(Cid as varchar(50))+'},',@str+',')>0 ) as a 15
on b.ParentID=a.cid16
GO
