create function getstr(@xu int)
returns varchar(8000)
as
begin
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+','+rtrim(state) from 一张表 where id=@xu
set @sql=right(@sql,len(@sql)-1)
return @sql
end
go
select id,dbo.getstring(id) state from 一张表 group by id
create function getstring(@xu int)
returns varchar(8000)
as
begin
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+','+rtrim(state) from t where id=@xu
set @sql=right(@sql,len(@sql)-1)
return @sql
end
go
select id,master.dbo.getstring(id)as state from t group by id