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