插入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

posted @ 2014-02-18 16:53  Develop  阅读(145)  评论(0编辑  收藏  举报