自己建立,如:
1,建自定义函数
create function getstr(@id Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+N',' from table
where xh=@id
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
endGO2,
select xh,dbo. getstr( xh) as xmmc from table group by xh
1,建自定义函数
create function getstr(@id Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+N',' from table
where xh=@id
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
endGO2,
select xh,dbo. getstr( xh) as xmmc from table group by xh
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货