This is what I need to complete, but I keep running into errors.

a. Create an Update Stored Procedure that will update one record in the Person Table based on the personID, do not update the pwd, or roleID fields with this stored procedure.

This is my stored procedure:

ALTER PROCEDURE [dbo].[updatePerson] -- Add the parameters for the stored procedure here @personID int, @firstName nvarchar(30), @lastName nvarchar(50), @email nvarchar(75), @phone nvarchar(10) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;

-- Insert statements for procedure here UPDATE kmtPerson SET firstName = @firstName, lastName = @lastName, email = @email, phone = @phone WHERE personID = @personID

END

When I execute the stored procedure, I keep getting this error:

Procedure or function 'updatePerson' expects parameter '@personID', which was not supplied.