解决 for xml path encode 的问题

select

stuff(

(select ', <' + name + '>'

from sys.databases

where database_id > 4

order by name

for xml path(''), type

).value('(./text())[1]','varchar(max)')

, 1, 2, '') as namelist;

上一篇:docker operation method note


下一篇:Common scenarios to avoid in OLTP