借助用户定义函数:create function f_tree()
returns @t table(CATEGORY_ID int identity(1,1),
PARENT_CATEGORY_ID int,
CATEGORY_NAME varchar(20),
ACTIVE_STATUS varchar(10))
as
begin
insert into @t(PARENT_CATEGORY_ID,CATEGORY_NAME,ACTIVE_STATUS)
select
PARENT_CATEGORY_ID,
CATEGORY_NAME,
ACTIVE_STATUS
from
TreeView return @t
end
go
select * from dbo.f_tree()
go
returns @t table(CATEGORY_ID int identity(1,1),
PARENT_CATEGORY_ID int,
CATEGORY_NAME varchar(20),
ACTIVE_STATUS varchar(10))
as
begin
insert into @t(PARENT_CATEGORY_ID,CATEGORY_NAME,ACTIVE_STATUS)
select
PARENT_CATEGORY_ID,
CATEGORY_NAME,
ACTIVE_STATUS
from
TreeView return @t
end
go
select * from dbo.f_tree()
go
说的方法!
不过,为了表示谢意!
决定给分!
呵呵~