create function getstr(@content varchar(100))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(area) from 现有一表 where name=@content
set @str=right(@str,len(@str)-1)
return @str
end
go
select name,dbo.getstr(name) areas from table1 group by name
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(area) from 现有一表 where name=@content
set @str=right(@str,len(@str)-1)
return @str
end
go
select name,dbo.getstr(name) areas from table1 group by name
create function getstr(@content varchar(100))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+','+rtrim(area) from 现有一表 where name=@content
set @str=right(@str,len(@str)-1)
return @str
end
go你在vb里直接用:
select name,dbo.getstr(name) areas from 现有一表 group by name
来查询呀!