Some excellent advice in this article, My stored procedure “best practices” checklist, posted by Aaron Bertrand.
“When developing stored procedures, there seems to be a lot of emphasis on “get it done fast.” Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window.”