tj_dns(愉快的登山者) ( )
1,建自定义函数
create function getstr(@Category Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+' ' from table1
where Category=@Category
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
end
GO
2,
select Category, dbo.getstr(Category) as Score from table1 group by Category
1,建自定义函数
create function getstr(@Category Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+N'|' from table1
where Category=@Category
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
end
GO
2,
select Category, dbo.getstr(Category) as Score from table1 group by Category