- if an author with AuthorID = @authorID already exists, the procedure does nothing.
7 of 7
Paper No: 5
- if there is no author with AuthorID = @authorID, the procedure will insert into the table Authors a new row with @authorID, @authorName, @country, @sex, @yearOfBirth as values for its attributes.
For example, when we execute the insertAuthor procedure with input values as in the following statement, a new author with the corresponding values will be inserted into the table Authors:
exec insertAuthor
@authorID = 100,
@authorName = 'Guillaum Musso',
Annuntai - Eronoo!
Close
+ 112%
Zoom
