提示必须声明@table 求助F姐姐 tony哥 乌龟哥 77哥 老黎哥

[sxiaohui8709253]

create function GetAllParents(@ID int)
returns @table table(ID int)
as
begin
declare @ParentID int
set @ParentID=@ID
while @ParentID<>0
begin
insert into @table(ID) select ID from A where ParentID= @ParentID
set @ParentID=(select top 1 ID from @table order by ID desc)
end
return @table
end

消息 137，级别 15，状态 2，过程 GetAllParents，第 12 行
必须声明标量变量 "@table"。

[blueclair]

正在学习ing

[sql_lover]

--return @table

[sxiaohui8709253]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER function [dbo].[GetAllParents](@ID int)
returns @table table(ID int)
as
begin
declare @ParentID int
set @ParentID=(select ID from A where ParentID= @ID)
while @ParentID!=0
begin
insert into @table(ID) select ID from A where ParentID= @ParentID
set @ParentID=(select top 1 ID from @table order by ID desc)
end
end

[fa_ge]

create function GetAllParents(@ID int)
returns @table table(ID int)
as  
begin
declare @ParentID int
set @ParentID=@ID
while @ParentID<>0
begin
insert into @table(ID) select ID from A where ParentID= @ParentID
set @ParentID=(select top 1 ID from @table order by ID desc)
end
return
end

[miss_chen106]

路过学习

[feixianxxx]

标题 写得倒是蛮全的 呵呵

[sxiaohui8709253]

他们一个都不来 我表示 我很伤心

[--小F--]

insert into @table(ID) select ID from A where ParentID= @ParentID
set @ParentID=(select top 1 ID from @table order by ID desc)
end
return @table
end

[wzy_love_sly]

77哥,这位应该是小弟弟

[亮剑_]

四个哥哥去拍三国了，今天演“三英战吕布”
姐姐演貂婵，今天休息在家

[sxiaohui8709253]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[GetAllParents](@ID int)
returns @table table(ID int)
as 
begin
declare @ParentID int
insert into @table(ID) select ParentID from A where ID=@ID 
set @ParentID=@ID
while @ParentID<>0
begin
set @ParentID=(select ParentID from A where ID= @ParentID)
insert into @table select * from [dbo].[GetAllParents](@ParentID)
end
return 
end

[永生天地]

表值函数，最后直接写return

[老黎]

惊见大名在标题，特来学习表值函数
向小宋学习

[you_tube]

[sxiaohui8709253]

我终于搞出来 大家别笑话我啊

ALTER function [dbo].[GetAllParents](@ID int)
returns @table table(ID int)
as 
begin
insert into @table(ID)values(@ID)
declare @ParentID int
set @ParentID=(select ParentID from A where ID=@ID)
insert into @table(ID)values(@ParentID)
while @ParentID<>0
begin
set @ParentID=(select ParentID from A where ID=@ParentID)
insert into @table(ID)values(@ParentID)
end
return
end

赶紧来人
结贴给分了

[htl258_Tony]

不好意思，来晚了