下面这个函数有这个错误,不知为什么? 错误444:函数中含有的select 语句无法向客户端返回数据

[clkun]

Create table a (dept_name nvarchar(20),dept_id Smallint)
Create table b (Stuffs Nvarchar(20),dept_id Smallint,s_id Smallint)
Insert Into a values ('办公室',1)
Insert Into a values ('财务室',2)
Insert Into b values ('张三',1,1)
Insert Into b values ('李四',1,2)
Insert Into b values ('王五',2,3)



下面这个函数有这个错误,不知为什么?

错误444:函数中含有的select 语句无法向客户端返回数据





Create Function lname (@id smallint)
RETURNS NVarchar
AS
Begin
Declare @New_Files NVarchar, @Stuffs_Name NVarchar, @s_id smallint
Declare Employee_Cursor Cursor For Select Stuffs,s_id from b Where dept_id = @id
Open Employee_Cursor
Fetch Next From Employee_Cursor
Into @Stuffs_Name, @s_id
While @@FETCH_STATUS = 0
Begin
Set @New_Files = @New_Files+'|||'+@Stuffs_Name + '|' + @s_id
Fetch Next From Employee_Cursor
End
RETURNS(@New_Files)
Close Employee_Cursor
Deallocate Employee_Cursor

End

GO

[vivianfdlpw]

函数中只能使用局部游标

[vivianfdlpw]

Create Function lname (@id smallint)
RETURNS NVarchar(4000)
AS
Begin
Declare @New_Files NVarchar(4000), @Stuffs_Name NVarchar(20), @s_id smallint
Declare @Employee_Cursor cursor
set @Employee_Cursor=cursor for Select Stuffs,s_id from b Where dept_id = @id
set @New_Files =''
Open @Employee_Cursor
Fetch Next From @Employee_Cursor Into @Stuffs_Name, @s_id
While @@FETCH_STATUS = 0
Begin
Set @New_Files = @New_Files+'|||'+@Stuffs_Name + '|' + @s_id
Fetch Next From @Employee_Cursor Into @Stuffs_Name, @s_id
End
Close @Employee_Cursor
Deallocate @Employee_Cursor

RETURN @New_Files

End

GO

[vivianfdlpw]

try

Create Function lname (@id smallint)
RETURNS NVarchar(4000)
AS
Begin
Declare @New_Files NVarchar(4000), @Stuffs_Name NVarchar(20), @s_id smallint
Declare Employee_Cursor Cursor For Select Stuffs,s_id from b Where dept_id = @id
set @New_Files =''
Open Employee_Cursor
Fetch Next From Employee_Cursor
Into @Stuffs_Name, @s_id
While @@FETCH_STATUS = 0
Begin
Set @New_Files = @New_Files+'|||'+@Stuffs_Name + '|' + @s_id
Fetch Next From Employee_Cursor
End
Close Employee_Cursor
Deallocate Employee_Cursor

RETURN @New_Files

End

GO

[vivianfdlpw]

Create Function lname (@id smallint)
RETURNS NVarchar(4000)
AS
Begin
Declare @New_Files NVarchar(4000)
set @New_Files =''

select @New_Files = @New_Files+'|||'+Stuffs_Name + '|' + s_id
from b Where dept_id = @id

RETURN @New_Files
End

GO

[clkun]

你第一次回答的还是有同样的问题?不知为什么?