create function myFunction(@sn int)
returns varchar(8000)
as
begin
declare @rtValue varchar(8000)
set @rtValue = ''
select @rtValue = @rtValue +questtion + ',' from table2 where sn=@sn
if(substring(rtrim(@rtValue),len(rtrim(@rtValue)),1) = ',')
begin
set @rtValue = substring(@rtValue,1,len(rtrim(@rtValue))-1)
end
return @rtValue
end
不错;谢谢提醒~~
create table table2
(
sn int,
questtion varchar(100)
)
insert into table1 values(100)
insert into table1 values(101)
insert into table2 values(100,'aaa')
insert into table2 values(100,'bbb')
insert into table2 values(100,'ccc')
insert into table2 values(101,'rrr')
insert into table2 values(101,'eee')
insert into table2 values(101,'ddd')
alter function myFunction(@sn int)
returns varchar(8000)
as
begin
declare @rtValue varchar(8000)
set @rtValue = ''
select @rtValue = @rtValue +questtion + ',' from table2 where sn=@sn
return @rtValue
end