@authorID = 100,
@authorName = 'Guillaum Musso',
@country = 'France',
@sex = 'Male',
@yearOfBirth = 1975;
But when we run the following statement to execute the insertAuthor procedure, the command completed successfully but no row will be inserted into the table Authors because an author with AuthorID = 1 already exists in the table.
exec insertAuthor
@authorID = 1,
@authorName = 'David Lodge',
@country = 'United States',
@sex = 'Male',
@yearOfBirth = 1908;
Question 9:
Create a trigger named deleteGenres for the delete statement on the "Genres" table so that
Close
+ 112%
Zoom
