select top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=3 and PaperDegree ='3' and KnowledgeTypeId in(2,3,4)union allselect top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=4 and PaperDegree ='4' and KnowledgeTypeId in(2,3,4)union allselect top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=5 and PaperDegree ='5'? 我的查詢語句是這樣的， 我寫的是一個存儲過程我傳值進(jìn)去的時候，例如 @QuestionTypeId varchar(50)，它的值是'3,4,5'，(也有可能是 '4,5,6,7 ')，也就是QuestionTypeId 的條件字段，根據(jù) ','來分割，在存儲過程里面應(yīng)該怎么分割呢？我希望做到的是 如果傳遞的值是 '3,4' 那么 查詢語句就是 select top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=3 and PaperDegree ='3' and KnowledgeTypeId in(2,3,4)union allselect top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=4 and PaperDegree ='4' and KnowledgeTypeId in(2,3,4)如果傳遞的值是'3,4,5'，那么查詢語句就是select top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=3 and PaperDegree ='3' and KnowledgeTypeId in(2,3,4)union allselect top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=4 and PaperDegree ='4' and KnowledgeTypeId in(2,3,4)union allselect top(10) PaperId,CreationTime,QuestionTypeId from TB_Paper where QuestionTypeId=5 and PaperDegree ='5'? 傳遞值具體是不確定的，有可能是 '3,4'，也有可能是'3,4,5,6'，也有可能是'3,4,5,6,7' 這樣該怎么寫呢？