stuff截取字符串

SELECT STUFF((
select '/'+convert(varchar,ID) from (
SELECT TOP 2 ID FROM dbo.T
) as a FOR XML PATH ('')
),1,1,'')

posted @ 2017-06-25 17:22  huanglongblog  阅读(189)  评论(0)  编辑  收藏  举报