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

/*
Name: USP _
Description: write description of the functionality of user Stored Procedure
author: Rickie
modification log: Change

description date changed by
created procedure 8 / 27 /200 4 Rickie
*/

STored procedure names usually begin with the prefix "USP _".