插入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
Original article, please indicate the source:http://develop.cnblogs.com
Mail:NeiTe@qq.com