华少.Net

 Create table test (name char(10),km char(10),cj int)goinsert test values(张三,语文,80)insert test values(张三,数学,86)insert test values(张三,英语,75)insert test values(李四,语文,78)insert test value

create function fmerg(@id int)returns varchar(8000)asbegindeclare @str varchar(8000)set @str=select @str=@str+,+ short_name from v_person where psn_code=@idset @str=right(@str,len(@str)-1)return(@