LISTING 4: Stored Procedure IinsertTitleNew

CREATE PROCEDURE IinsertTitleNew 
(@Title_id char(6), @Title char(80), @Type char(12), @notes char(200)) AS

insert titlesnew (Title_id, title, type, notes) 
values (@Title_id, @Title,@Type,@notes)