1
declare
@a
int
,
@b
int
2 set @a = 1
3 set @b = 1
4 while @a < 100000
5 begin
6 insert into test_table (news_title,news_content) values ( @a , @b )
7 set @a = @a + 1
8 set @b = ( @a + 1 ) * 5 - 2
9 end
2 set @a = 1
3 set @b = 1
4 while @a < 100000
5 begin
6 insert into test_table (news_title,news_content) values ( @a , @b )
7 set @a = @a + 1
8 set @b = ( @a + 1 ) * 5 - 2
9 end