摘要：初学 SQL Server ，看见作者第四章“查询优化”的样本数据中有一段代码，如下：DECLARE @max AS INT, @rc AS INT;SET @max = 1000000;SET @rc = 1;INSERT INTO dbo.Nums(n) VALUES(1);WHILE @rc * 2 <= @maxBEGIN INSERT INTO dbo.Nums(n) SELECT n + @rc FROM dbo.Nums; SET @rc = @rc * 2;ENDINSERT INTO dbo.Nums(n) SELECT n + @rc FROM dbo.Nums WH 阅读全文
浙公网安备 33010602011771号