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

CREATE FUNCTION dbo.ufn_GetProjectAttachments (@tnProjectId BIGINT)RETURNS VARCHAR(400)ASBEGIN 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 @lsAttachmentsEND