declare @sql varchar(8000)
set @sql=''
select @sql=@sql+','+mName+'' from from mTable where id='1'
set @sql=stuff(@sql,1,1,'')
set @sql='select '''+@sql+''''
exec(@sql)
create function f_str(@ID int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+'、'+mName from mtable where ID=@ID
return stuff(@str,1,1,'')
end
go
--查询
select [mName]=dbo.f_str(ID) from mTable where id='1'