我的第一个M-SQL自定义函数

CREATE FUNCTION dbo.ufn_GetProjectAttachments (@tnProjectId BIGINT) RETURNS VARCHAR(400) AS BEGIN  DECLARE @lsAttachments varchar(400)      DECLARE @lsAttachment varchar(50)  SET @lsAttachments = ''  SET @lsAttachment = ''     DECLARE loAttachmentCur CURSOR LOCAL FOR   SELECT AttachmentName  FROM ProjectAttachment WHERE ProjectId=@tnProjectId    OPEN loAttachmentCur     FETCH NEXT FROM loAttachmentCur INTO @lsAttachment     WHILE @@FETCH_STATUS = 0  BEGIN   IF(@lsAttachments = '' )    SET @lsAttachments = @lsAttachment   ELSE    SET @lsAttachments = @lsAttachments + ',' + @lsAttachment

  FETCH NEXT FROM loAttachmentCur INTO @lsAttachment  END    CLOSE loAttachmentCur

     RETURN @lsAttachments END