先写一个函数
[code]
create function contact(@section varchar(32))
returns varchar(64)
as
begin
declare @ret varchar(8000)
set @ret=''
select @ret=@ret+','+rtrim(name)
from T_PEOPLE
where section=@section
return(@ret)
end
go
[/code]
再调用
[code]
select section,name=contact(section) from T_PEOPLE group by section
[/code]
[code]
create function contact(@section varchar(32))
returns varchar(64)
as
begin
declare @ret varchar(8000)
set @ret=''
select @ret=@ret+','+rtrim(name)
from T_PEOPLE
where section=@section
return(@ret)
end
go
[/code]
再调用
[code]
select section,name=contact(section) from T_PEOPLE group by section
[/code]
1067
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
