摘要：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(@... 阅读全文

摘要：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(@... 阅读全文