插入N条测试数据

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

原文地址:https://www.cnblogs.com/develop/p/3554531.html