set nocount on
declare @num int
declare @dataCount int
declare @i int
SET @i = 0
SET @dataCount = 500000
WHILE @i<@dataCount
BEGIN
     SET @i = @i + 1
     insert into dbo.CT (TName,TDate,TypeA,TypeB,TypeC,TypeD,TypeE,Price,Status) values ('name', '2000-01-01', CEILING(RAND()*5),CEILING(RAND()*5),CEILING(RAND()*5),CEILING(RAND()*5),CEILING(RAND()*5), CEILING(RAND()*5000 + 5000), CEILING(RAND()*2))
END
posted on 2008-04-28 10:25  大斌锅  阅读(678)  评论(0)    收藏  举报