You need to insert two new products into the Product table. The first product is named Book and has
an ID of 125. The second product is named Movie and has an ID of 126.
Which statement should you use?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
B
0
1
B is correct.
You dont have to specify twice INSERT INTO, (forgot the ,) this works also:
INSERT INTO dbo.Product (ID, Name)
VALUES (‘125’, ‘book’), (‘126’, ‘movie’);
7
0