I need to create a store procedure that will update a table. An Classic ASP page is calling and writing the info.
I am not sure how to begin. In Wrox' Professional Active Server Pages 3.0 pages 366 to 369, it shows how to insert but not update.

Do anyone have an example of a stored procedure that updates a table accessed by an ASP page?

have a look at how the store procedures works using enteprise manager or google for it.
Insert and update is kind of same, only the second one will require a "where" clause.