Create Procedure InsertAuthor
@authid         int,
@surname        varchar(40),
@firstname       varchar (40),
@phonetic       varchar (4)
As
   insert into Author 
      (AuthorID, Surname, FirstName, PhoName)
   values
      (@authid, @surname, @firstname, @phonetic)
   return