sqlserver 自定义函数返回表类型

use WANSYSTEMDBgo create function query_question_option(@pid int)returns @temptale table(pid int ,optionstr varchar(5000))asbegindeclare @fullText varchar(5000)set @fullText=''select @fullText=@fullText+oflag+soption+'>>' from question_option where qid=@pidinsert into @temptale values(@pid,@fullText)returnend