Re: Begin/end, I think this is a good programming practice and it shows that you intentionally put certain code in the procedure. If you're executing the code under the gun, I assume you're changing the parameters to a DECLARE? I would note that's likely a more advanced concept.

The "basics" is just that. I feel that sometimes we try to write all encompassing articles that become too long and confusing for  someone that wants to get started. I'd like to see more developers start using these, and my view is that the ought to try and write some based on a quick introduction.

I may try to write something more advanced than this, but it's a question of time and resources. Someone else is welcome to do so if they like.