Inserts 3000 row into a table : Batch Insert « Insert Delete Update « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Insert Delete Update
3. Batch Insert

Inserts 3000 row into a table

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


           
       

Related examples in the same category