另一种将有分隔符的数据导入到临时表中的方案

qzyf1992

于 2015-05-05 14:11:00 发布

阅读量797

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qzyf1992/article/details/45501813

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

IF(OBJECT_ID('tempdb..#TMP')) IS NOT NULL
BEGIN
	TRUNCATE TABLE #TMP
	DROP TABLE #TMP
END

CREATE 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)
BEGIN
SET @Area = 'INSERT INTO #TMP 
SELECT * FROM (SELECT '''+REPLACE(@Area,',',''' as str11 UNION ALL SELECT ''')+''') A'
END
ELSE
BEGIN
SET @Area =	'INSERT INTO #TMP SELECT * FROM (SELECT '''+@Area+''' as str11) A'
END


PRINT @Area
EXEC(@Area)
SELECT * FROM #TMP