When you write stored procedures (especially for a business or academic project), you never know who will eventually have to alter the code. This top section is useful for comments about the stored procedure, a change log, and other pertinent information. While this is not required, it is just a good programming habit. For your stored procedures, make it look like this:
/*
Name: usp_ProcedureName
Description: write description of the functionality of user stored procedure
Author: Rickie
Modification Log: Change
Description Date Changed By
Created procedure 8/27/2004 Rickie
*/
Stored procedure names usually begin with the prefix "usp_".