8 of 8
Paper No: 6
@address=null,
@email='
[email protected]',
@sex='Male',
@birthDate='1989-10-14';
But when we run the following statement to execute the insertMember procedure, the command completed successfully but no row will be inserted into the table Members because a member with MemberID = 2 already exists in the table.
execute insertMember
@memberID = 2,
@memberName='John Wilson',
@address=null,
@email='
[email protected]',
@sex='Male',
@birthDate='1976-11-10';
Question 9:
Create a trigger named deleteGenres for the delete statement on the "Genres" table so that when we call a delete statement to delete one or more rows from the "Genres" table, the system will automatically update the table Books to set GenreID as NULL for all books of the deleted genres.
For example, if we call the following statement to delete 2 genres with GenreID = 1 and GenreID = 2 from the "Genres" table, all the books of these two genres will be updated so that the GenreID of these books will be NULL.
delete from Genres where GenreID in (1,2)
Question 10:
Write statement to update the GenreID of the book named 'The Castle' so that this book will belong to the genre named 'Romance'
+ 100%
Close
