have an insert statement to an assignment table that will be use for grading by

Question

have an insert statement to an assignment table that will be use for grading by populating this script with your pantherId, firstname, lastname, databasename and assignment (1, 2 or 3) /***This must be created for every assignment and must be done at the beginning) ****/ insert into master . dbo . assignments ( pantherId , firstname , lastname , databasename , assignment ) values ( '7777777' , 'John' , 'Smith' , 'Smith_J7777777' , 1 ) GO /*******************************************************************************/

please help insert statement to an assignment table

show example please

Explanation / Answer

Hi.

If we consider the PantherID as the primary key, then the insert statements for Assignment 1,2, 3 can be written as below-

insert into master . dbo . assignments( pantherId , firstname , lastname , databasename , assignment ) values ( '8888888' , 'Sam' , 'John' , 'John_J8888888' , 2 ) ;

insert into master . dbo . assignments( pantherId , firstname , lastname , databasename , assignment ) values ( '9999999' , 'Michael' , 'Sandy' , 'Sandy_J9999999' , 3 ) ;

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.