Avinash's

SQL Knowledge Sharing
In SQL, if we want to enter multiple records using INSERT Statement . we can do it in two ways....
Suppose there is one table named as student with following columns:
Student
Column Name Data Type Nullable
StudentID INT No
StudentName Varchar(128) No
StudentClass Varchar(15) No
StudentContact Varchar(1024) No
Description Varchar(2048) Yes

Note:Here CustomerID is Primary Key and identity column

To insert 10 students records we can either write 10 INSERT statements or we can write 1 INSERT statement

1. Individual Insert Statements for each record


INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student A','10th Class','9876543210','Description 10' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student B','9th Class','8765432109','Description 9' )
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description);
VALUES('Student C','8th Class','7654321098','Description 8' )
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student D','7th Class','6543210987','Description 7' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student E','6th Class','5432109876','Description 6' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student F','5th Class','4321098765','Description 5' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student G','4th Class','3210987654','Description 4' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student H','3rd Class','2109876543','Description 3' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student I','2nd Class','1098765432','Description 2' );
INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact)
VALUES('Student J','1st Class','0987654321' );

2. Single INSERT statement for multiple rows


INSERT INTO TABLE Student(StudentName,StudentClass ,StudentContact ,Description)
VALUES('Student A','10th Class','9876543210','Description 10' ),
('Student B','9th Class','8765432109','Description 9' ),
('Student C','8th Class','7654321098','Description 8' ),
('Student D','7th Class','6543210987','Description 7' ),
('Student E','6th Class','5432109876','Description 6' ),
('Student F','5th Class','4321098765','Description 5' ),
('Student G','4th Class','3210987654','Description 4' ),
('Student H','3rd Class','2109876543','Description 3' ),
('Student I','2nd Class','1098765432','Description 2' ),
('Student J','1st Class','0987654321' ,NULL );

The Customer Table looks like this...

StudentID StudentName StudentClass StudentContact Description
1 Student A 10th Class 9876543210 Description 10
2 Student B 9th Class 8765432109 Description 9
3 Student C 8th Class 7654321098 Description 8
4 Student D 7th Class 6543210987 Description 7
5 Student E 6th Class 5432109876 Description 6
6 Student F 5th Class 4321098765 Description 5
7 Student G 4th Class 3210987654 Description 4
8 Student H 3rd Class 2109876543 Description 3
9 Student I 2nd Class 1098765432 Description 2
10 Student J 1st Class 0987654321 NULL