CREATE TABLE employee (emp_no INTEGER NOT NULL,
emp_fname CHAR(20) NOT NULL,
emp_lname CHAR(20) NOT NULL,
dept_no CHAR(4) NULL)
insert into employee values(1, 'Matthew', 'Smith', 'd3')
insert into employee values(2, 'Ann', 'Jones', 'd3')
insert into employee values(3, 'John', 'Barrimore','d1')
insert into employee values(4, 'James', 'James', 'd2')
insert into employee values(5, 'Elsa', 'Bertoni', 'd2')
insert into employee values(6, 'Elke', 'Hansel', 'd2')
insert into employee values(7, 'Sybill', 'Moser', 'd1')
select * from employee
GO
-- This procedure inserts 3000 row in the table employee
SET SHOWPLAN_TEXT OFF
GO
declare @i integer, @emp_no integer
declare @emp_Iname char(20), @emp_fname char(20)
declare @dept_no char(4)
set @i = 1
set @emp_Iname = 'Smith'
set @emp_fname = 'Jane'
set @dept_no = 'd1'
while @i < 3001
begin
insert into employee
values (@i, @emp_fname, @emp_Iname, @dept_no)
set @i = @i+1
end
select count(*) from employee
GO
drop table employee
GO