SQL Server存储过程模板

create/alter <SP Name>

/*---------------------------------------------------------------------------
DESCRIPTION:
This procedure will get the list of users.

AUTHOR:
DATE:

PARAMETERS:
Parameter 1: Description of parameter1 
Parameter 2: Description of parameter2

RETURN VALUE:

AFFECTED TABLES:
Table1
Table2
---------------------------------------------------------------------------*/

@DiscussionID uniqueidentifier
...
as

begin

      -- other declare statements

      declare @Error int