create function getstr(@fieldA Nchar(20))
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+N','+rtrim(fieldB) from tblA
where fieldA=@fieldA
set @str=right(@str,len(@str)-1)
return @str
end
GO调用:select distinct fieldA,dbo.getstr(fieldA) as fieldB from tbl
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+N','+rtrim(fieldB) from tblA
where fieldA=@fieldA
set @str=right(@str,len(@str)-1)
return @str
end
GO调用:select distinct fieldA,dbo.getstr(fieldA) as fieldB from tbl
as
begin
declare @list varchar (400)
select @list=''
select @list =@list + fieldB from tblA where fieldA =@name
return @list
end
go
select fieldA ,dbo.getlist(fieldA) from tblA group by fieldA
这种做法oracle支持吗?谢谢
2、我的写错了,多了逗号。