sql语句查询某列值并用','连接

create function [dbo].[f_str]() returns nvarchar(1000)
as begin 
declare @str nvarchar(1000)
set @str = ''
	select @str = @str + ',' + cast(BaseSetID as nvarchar(900))
	from 表名
set @str = right(@str,len(@str) - 1)
return @str 
end



select 
count(BaseSetID) as '总列数',
[dbo].[f_str]() as '全部列所组成的字符串' from 表名
上表查询得到的结果如下：