there are places for improvement, and the code in the article was updated in an earlier comment. I have updated the article to reflect that.

I think SELECT is a good thing to add. I have added 2 SELECT procs in my own generation procs before. One to return all values, and one to return a specific value. I've had the need for both those procs in many tables.