摘要: 我只把我现在用的方法列出来:1.建立一个辅助表,里面只有一列,内容为0-100W个数CREATE TABLE Nums(n INT NOT NULL PRIMARY KEY);insert into Nums values (0)DECLARE @max AS INT,@rc AS INT;SET @max = 1000000;SET @rc=1;INSERT INTO Nums VALUES (1);WHILE @rc * 2 <=@max BEGIN INSERT INTO Nums SELECT n+@rc FROM Nums; SET @rc=@rc * 2; ... 阅读全文
posted @ 2013-01-12 09:08 草根豆 阅读(593) 评论(0) 推荐(0) 编辑