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
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
CREATE FUNCTION uf_hxsj(@id int)
RETURNS varchar(200) AS
begin
declare @jg varchar(200)
set @jg=''
select @jg= @jg+state from 表 where id=@idreturn @jg
end
select distinct id,dbo.uf_hxsj(id) from 表
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