SQL Bulk Insert Example

This page discusses - SQL Bulk Insert Example

SQL Bulk Insert Example

SQL Bulk Insert Example

     

SQL Bulk Insert Example is used to insert a bulk record to the table.

Understand with Example

The Tutorial illustrate an Example to create SQL Bulk Insert .To grasp this example we create a table 'Stu_Table'.  The create table statement  create a table 'Stu_Table' with table attribute like 'field attribute' and 'data type'.

Create Table Stu_Table

 

 

 

 

Create Table Stu_Table( Stu_Id int, Stu_Name varchar(15),Stu_Class());

Insert Data Into Stu_Table

The insert into add the records or rows to the table 'stu_table' with respective values.

insert into stu_table values
			(1, 'Komal',10),
			(2, 'Ajay',10),
			(3, 'Santosh',10),
			(4, 'Rakesh',10),
			(5, 'Bhau',10);
insert into stu_table values
			(1, 'aaa',11),
			(2, 'bbb',11),
			(3, 'ccc',11),
			(4, 'ddd',11),
			(5, 'eee',11);
insert into stu_table values
			(1, 'iii',12),
			(2, 'jjj',12),
			(3, 'kkk',12),
			(4, 'lll',12),
			(5, 'mmm',12);

Stu_Table

+--------+----------+-----------+
| Stu_Id | Stu_Name | Stu_Class |
+--------+----------+-----------+
| 1      | Komal    | 10        |
| 2      | Ajay     | 10        |
| 3      | Santosh  | 10        |
| 4      | Rakesh   | 10        |
| 5      | Bhau     | 10        |
| 1      | aaa      | 11        |
| 2      | bbb      | 11        |
| 3      | ccc      | 11        |
| 4      | ddd      | 11        |
| 5      | eee      | 11        |
| 1      | iii      | 12        |
| 2      | jjj      | 12        |
| 3      | kkk      | 12        |
| 4      | lll      | 12        |
| 5      | mmm      | 12        |
+--------+----------+-----------+