SQL Server 2000某字段的多条记录合并成一行显示
create function joinLine(@param int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+[ThemeDepot_Name] from [Sys_ThemeDepot] where 1=1
set @str=right(@str,len(@str)-1)
print(@str)
return(@str)
End
go
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+[ThemeDepot_Name] from [Sys_ThemeDepot] where 1=1
set @str=right(@str,len(@str)-1)
print(@str)
return(@str)
End
go