笔记77 插入数据基数行偶数行

笔记77 插入数据基数行偶数行

--插入数据基数行偶数行
USE pratice
DECLARE @MyCounter INT
DECLARE  @rownumber INT
SET @MyCounter = 1 /*设置变量*/
SET @rownumber =0

WHILE @MyCounter <=10  --执行3次，第一次@MyCounter <300000 30W条记录 第二次@MyCounter <300000 60W条记录 第三次@MyCounter <400000 40W条记录
BEGIN

SELECT TOP 1 @rownumber= a FROM dbo.test ORDER BY a DESC
IF   (@rownumber+1)%2<>0
INSERT INTO dbo.test
SELECT @MyCounter,'坏人','2011-8-1 21:21:00','基数',@MyCounter
ELSE
INSERT INTO dbo.test
SELECT @MyCounter,'坏人','2011-8-2 21:21:00','偶数',@MyCounter

SET @MyCounter = @MyCounter + 1
END

--看一下现在表有多少条记录
--SELECT COUNT(*) FROM dbo.test

--DELETE FROM dbo.test
SELECT * FROM dbo.test