html5模板網 > > 數據庫問題 >
• SQL“東西"和“FOR XML PATH"生成奇怪的符號

 CONVERT(NVARCHAR(2000),stuff((SELECT '; ' + IsNull(D2.SelectedComments,'')來自#StudentDetails D2WHERE D2.STUD_PK = A.STUD_PK AND D2.CourseNo = A.CourseNoAND D2.Section = A.SectionFOR XML PATH('')),1,2,'')) AS SelectedComments,

>

, 東西((選擇 ';' + IsNull( D2.SelectedComments, '' )來自#StudentDetails 作為 D2其中 D2.Stud_PK = A.Stud_PK和 D2.CourseNo = A.CourseNoD2.Section = A.Section對于 Xml Path('')，輸入).value('.', 'nvarchar(max)'), 1, 2, '') 作為 SelectedComments

I have the following query inside a larger Select statement in SQL Server:

 CONVERT(NVARCHAR(2000),stuff((SELECT '; ' + IsNull(D2.SelectedComments,'')
 FROM #StudentDetails D2
 WHERE D2.STUD_PK = A.STUD_PK AND D2.CourseNo = A.CourseNo
AND D2.Section = A.Section
FOR XML PATH('')),1,2,'')) AS SelectedComments,

This column is generating some strange symbols after certain entries such as This approach is satisfactory .&#x0D. I don't understand where the .&#x0D is coming from. I tried doing SELECT SelectedComments FROM #StudentDetails right before this and I don't see the .&#x0D. Can anyone tell where it could be coming from?

If you modify your use of For Xml Path, it will do the unescaping for you and you won't need to resort to using the Replace function:

,   Stuff(
        (
        Select '; ' + IsNull( D2.SelectedComments, '' )
        From #StudentDetails As D2
        Where D2.Stud_PK = A.Stud_PK
            And D2.CourseNo = A.CourseNo
            And D2.Section = A.Section
        For Xml Path(''), type
        ).value('.', 'nvarchar(max)')
        , 1, 2, '') As SelectedComments

這篇關于SQL“東西"和“FOR XML PATH"生成奇怪的符號的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！