declare @x int
set @x=20100;
while (@x<21000)
begin
INSERT INTO
Customer(cardno,typeid,birday,lastdate,state,bcndate,createdate,lastcalldate,fare,cent)
VALUES(10000+@x,5,‘2000-10-1‘,‘2025-10-1‘,‘正常‘,0,‘2014-02-18
14:57:53‘,‘2014-02-18 14:57:53‘,1,0)
set @x=@x+1
end
原文：http://www.cnblogs.com/develop/p/3554531.html