Records should be inserted child table along with master table in sql server

Hi,
one of the interviewer has asked the below question sqlerver.
Records should be inserted child tables along with master table in sql server without using the stored procedure.could anyone please tell me the solution

Regards,
Venkat