create function getstr(@id Nchar(10))
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+N','+rtrim(name) from b
where rec_id=@id
set @str=right(@str,len(@str)-1)
return @str
end
GO
调用:
select a.rec_id,dbo.getstr(a.rec_id),a.aa,a.bb from a