1
--
=============================================
2 -- Author: 肖 楠
3 -- Create date: 2007年11月8日
4 -- Description: 插入10000条数据
5 -- =============================================
6 drop procedure Addshuju -- 删除
7
8
9 CREATE PROCEDURE AddShuJu
10 @name varchar ( 50 )
11 AS
12
13 begin
14 declare @i int
15 set @i = 0
16 while ( @i <= 10000 )
17 BEGIN
18 -- insert into [dbo].[User] values (@name)
19 update [ User ]
20 set name = @name
21 set @i = @i + 1
22 END
23 end
24
25 -- 调用
26 exec AddShuJu @name = ' xiaodingchuan '
27
28 -- 查询
29 select name as 学生姓名 from [ User ]
2 -- Author: 肖 楠
3 -- Create date: 2007年11月8日
4 -- Description: 插入10000条数据
5 -- =============================================
6 drop procedure Addshuju -- 删除
7
8
9 CREATE PROCEDURE AddShuJu
10 @name varchar ( 50 )
11 AS
12
13 begin
14 declare @i int
15 set @i = 0
16 while ( @i <= 10000 )
17 BEGIN
18 -- insert into [dbo].[User] values (@name)
19 update [ User ]
20 set name = @name
21 set @i = @i + 1
22 END
23 end
24
25 -- 调用
26 exec AddShuJu @name = ' xiaodingchuan '
27
28 -- 查询
29 select name as 学生姓名 from [ User ]