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;
解决 for xml path encode 的问题
原文：http://www.cnblogs.com/tangruixin/p/4490521.html
