ALTER FUNCTION dbo.Function1
(
@id int
)
RETURNS @mm table(id int,cou int identity)
AS
begin
declare @tb table(id int,cou int identity)
declare @sum int
INSERT @tb SELECT ID FROM 推荐单位表 WHERE 上级单位ID in (SELECT ID FROM 推荐单位表 WHERE (上级单位ID = @id))
set @sum=@@rowcount
if(@sum>0)
begin
while (@sum>0)
begin
declare @ins int
SELECT @ins=id FROM @tb WHERE cou=@sum
insert @mm select dbo.Function1( @ins )
set @sum=@sum-1
end
end
else
begin
insert @mm select @id
end
RETURN
end对象名 'dbo.Function1' 无效。
(
@id int
)
RETURNS @mm table(id int,cou int identity)
AS
begin
declare @tb table(id int,cou int identity)
declare @sum int
INSERT @tb SELECT ID FROM 推荐单位表 WHERE 上级单位ID in (SELECT ID FROM 推荐单位表 WHERE (上级单位ID = @id))
set @sum=@@rowcount
if(@sum>0)
begin
while (@sum>0)
begin
declare @ins int
SELECT @ins=id FROM @tb WHERE cou=@sum
insert @mm select dbo.Function1( @ins )
set @sum=@sum-1
end
end
else
begin
insert @mm select @id
end
RETURN
end对象名 'dbo.Function1' 无效。
应该怎么解决
第一句需要用
create function ....而不是alter funciton
这个是修改函数语句