T-SQL XQUERY.VARIABLE

DECLARE @bn NVARCHAR(max) = '剑'SELECT ArthurName,Region,CONVERT(NVARCHAR(max),BooksXML.query('for $s in /books/booklet $n := data($s/@name)let $p := concat($n,"-")where $s/@name[contains(.,sql:variable("@bn"))]order by $preturn $p')) AS BookListFROM[dbo].[Arthur]

ArthurName Region BookList
金庸 香港 书剑恩仇录- 碧血剑-
古龙 台北 三少爷的剑- 多情剑客无情剑- 流星·蝴蝶·剑- 浣花洗剑录-
梁羽生 香港 七剑下天山-