Question

We are using Microsoft SQL 2017 for Database Administration. Please provide a detailed explanation. Thank you.  

20. Insert 4 records into the table tblModule4 yourInitials

Answer 1

 $\color{red}\underline{Answer:}$ 

INSERT INTO tblModule4_yourInitials VALUES (1,'tom','123456',1/1/1990,'F',NOW(),'someone1');
INSERT INTO tblModule4_yourInitials VALUES (2,'cat','123457',2/1/1990,'F',NOW(),'someone2');
INSERT INTO tblModule4_yourInitials VALUES (3,'ram','123458',3/1/1990,'M',NOW(),'someone3');
INSERT INTO tblModule4_yourInitials VALUES (4,'bob','123459',4/1/1990,'M',NOW(),'someone4');