MSSQL 拆分逗号隔开的数据 Split方法.
--MSSQL 拆分逗号隔开的数据 Split方法.--创建辅助表CREATE TABLE Nums(Rn int NOT NULL PRIMARY KEY);GO ;WITH t1 AS (SELECT 1 AS c UNION ALL SELECT 1 ) --SELECT * FROM t1;,t2 AS (SELECT 1 AS c FROM t1 AS a,t1
原创
2013-12-10 12:45:46 ·
5096 阅读 ·
2 评论
关注
分享
扫一扫