A Simple Tip on SQL Server Stored Procedure

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_".