62,067
社区成员
发帖
与我相关
我的任务
分享
ALTER FUNCTION dbo.ArticleClass_Show(@rootID int)
RETURNS @tb TABLE(ClassID int,ClassName nvarchar(200))
AS
begin
insert into @tb(ClassID,ClassName) select ClassID,ClassName from ArticleClass where ClassID=@rootID
declare mycursor cursor for select ClassID from ArticleClass where ParentClassID=@RootID
Open mycursor
declare @ClassID int
fetch next from mycursor into @ClassID
while @@fetch_status=0
begin
insert into @tb(ClassID,ClassName)
select ClassID,[ClassName] from dbo.ArticleClass_Show(@ClassID)
fetch next from mycursor into @ClassID
end
Close mycursor
deallocate mycursor
return
end