Write a stored procedure called AddReviewer that will add a new row to the Reviewer table. Ensure that none of the parameters are less than two characters long and raise an appropriate error message if they are. Return the database generated ReviewerID if the insert was successful.

ERD Director Genre MovieStudio Legend DirectorID int PK GenreCode int PK MovieStudioID int PK FirstName varchar(30) GenreName varchar(30) MovieStudioName varchar(50) One Many LastName varchar(30) City varchar(30) Primary Key - PK Province char(2) Foreign Key - FK Phone char(12) Email varchar(50) ContactFirstName varchar(30) ContactLastName varchar(30) Reviewer Rating Movie Crew Position ReviewerID int PK RatingCode tiny int PK MovieID int PK CrewID int PK PositionID int PK FirstName varchar(30) RatingDescription varchar(50) Title varchar(80) FirstName varchar(30) PositionName varchar(40) LastName varchar(30) ReleaseDate smalldatetime LastName varchar(30) Organization varchar(50) Length small int Budget money ProjectedRevenue money DirectorID (FK) int GenreCode (FK) int MovieStudioID (FK) int MovieCrew MovieReview MovieID (FK) int MovieID (FK) int CrewID (FK) int ReviewerID (FK) int Wage small money RatingCode (FK) tiny int PositionID (FK) int P