27,579
社区成员
发帖
与我相关
我的任务
分享
DECLARE @STR VARCHAR(500)
DECLARE @SQL VARCHAR(5000)
SET @STR='tb,张三,IT,85622125,511122198002120014,四川成都,英语四级'
SET @SQL='SELECT COL='''+REPLACE(@STR,',',''''+CHAR(10)+' UNION ALL SELECT ''')+''''
PRINT @SQL
SELECT COL='tb'
UNION ALL SELECT '张三'
UNION ALL SELECT 'IT'
UNION ALL SELECT '85622125'
UNION ALL SELECT '511122198002120014'
UNION ALL SELECT '四川成都'
UNION ALL SELECT '英语四级'