IF(OBJECT_ID('tempdb..#TMP')) IS NOT NULLBEGINTRUNCATE TABLE #TMPDROP TABLE #TMPENDCREATE TABLE #TMP(str11 VARCHAR(200))DECLARE @Area VARCHAR(500)SET @Area = '0-60,60-90,90-120,120-160,160-200,200-300,300-400,400-99999999'IF(CHARINDEX(',',@Area)>0)BEGINSET @Area = 'INSERT INTO #TMP SELECT * FROM (SELECT '''+REPLACE(@Area,',',''' as str11 UNION ALL SELECT ''')+''') A'ENDELSEBEGINSET @Area ='INSERT INTO #TMP SELECT * FROM (SELECT '''+@Area+''' as str11) A'ENDPRINT @AreaEXEC(@Area)SELECT * FROM #TMP
，当一个人把寂寞当作人生预约的美丽，
