SQL Server 字段拆分的小技巧

290112011

　　一般的时候数据库设计中，有一对多或多对多的关系往往会设计一个表来存储这种关系的对应，但有时数据库结构我们是不能修改的，只能允许我们读取，现在假如有一下的数据表，需要我们来拆分字段char_array了。
http://images.iyunv.com/cnblogs_com/weiweictgu/1.gif
　　有一段有趣的SQL 代码可以很好的解决这个问题：
　　
　　

http://www.iyunv.com/Images/OutliningIndicators/ContractedBlock.gifhttp://www.iyunv.com/Images/OutliningIndicators/ExpandedBlockStart.gif创建辅助数据表
1http://www.iyunv.com/Images/OutliningIndicators/None.gifIF OBJECT_ID('dbo.Nums') IS NOT NULL
2http://www.iyunv.com/Images/OutliningIndicators/None.gif  DROP TABLE dbo.Nums;
3http://www.iyunv.com/Images/OutliningIndicators/None.gifGO
4http://www.iyunv.com/Images/OutliningIndicators/None.gifCREATE TABLE dbo.Nums(n INT NOT NULL PRIMARY KEY);
5http://www.iyunv.com/Images/OutliningIndicators/None.gifDECLARE @max AS INT, @rc AS INT;
6http://www.iyunv.com/Images/OutliningIndicators/None.gifSET @max = 1000000;
7http://www.iyunv.com/Images/OutliningIndicators/None.gifSET @rc = 1;
8http://www.iyunv.com/Images/OutliningIndicators/None.gif
9http://www.iyunv.com/Images/OutliningIndicators/None.gifINSERT INTO Nums VALUES(1);
10http://www.iyunv.com/Images/OutliningIndicators/None.gifWHILE @rc * 2