CURSOR 指针

ALTER FUNCTION [dbo].[fn_Report_GetPRApprovalUser](@PRID int)
RETURNS nvarchar(3000)
AS
begin
 -- Add the SELECT statement with parameter references here
 declare @ApprovalUser nvarchar(3000)
 declare @UserName nvarchar(100)
 declare @UserID int
 set @UserID = 0
 set @UserName = ''
 set @ApprovalUser = ''

 DECLARE Approval_cursor CURSOR FOR
 select UserID from prapproval where PRID = @PRID

 OPEN Approval_cursor
 FETCH NEXT FROM Approval_cursor INTO @UserID
 
 WHILE @@FETCH_STATUS = 0
 BEGIN

  select @UserName = ADLoginName from aduser where aduserid = @UserID
  set @ApprovalUser = @ApprovalUser + @UserName + ' '

  FETCH NEXT FROM Approval_cursor INTO @UserID
 END

 CLOSE Approval_cursor
 DEALLOCATE Approval_cursor

 return (@ApprovalUser)

end