Stored Procedures
Add comments inside the stored procedure.
When commenting, think about the person who has to modify this stored procedure at some point in the future. If the logic or flow is not obvious, comment it thoroughly.
If triggers will be fired when a stored procedure is called, add a comment that guides the reader to the code. Don't explain what the trigger is doing. Let them get that detail from the trigger code.
Tables
Add comments in the comment block.