Microsoft-SQL-Server-Development-for-Everyone/insert_students.sql at main · NotTheMomma/Microsoft-SQL-Server-Development-for-Everyone · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
use school

-- INSERT INTO TableName(Columns...) VALUES (values....)
-- Single Row Insert
insert into Students(firstname, lastname, dateofbirth, enrollmentdate) values
('Test', 'Student', '2001-09-03', null) -- Use a

-- INSERT INTO TableName(Columns...) VALUES (values....), (values....), (values....)
-- Multiple Row Insert
insert into Students(firstname, lastname, dateofbirth, enrollmentdate) values
('Test', 'Student', '2001-09-03', null), -- Use a
('Test11', 'Student11', '2000-01-08', '2019-03-05'),
('Test2', 'Student2', '2000-02-08', null),
('Test3', 'Student3', '2000-03-08', '2019-03-05'),
('Test4', 'Student4', '2000-04-08', null),
('Test5', 'Student5', '2000-05-08', null),
('Test6', 'Student6', '2000-06-08', '2019-03-05')