SQL多行合并与HTML组装，不转义特殊字符

declare  @t table(itemid int,val nvarchar(4000))

insert into @t(itemid,val)
select itemid,'<img id="img' + ltrim(rtrim(id)) + '" src="' + SignFile + '" style="width:150px">'
from TableName

select * from @t

SELECT  itemid,value=STUFF((
(select val from @t
--where Filetype=@Filetype and Fileid=@Fileid and Templateid=@Templateid and nodestate>0
FOR XML PATH(''),type).value('.','NVARCHAR(MAX)')
), 1, 0, '') 
FROM @t 
group by itemid