【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“NEWSPROC.SQL”一文,供大家参考学习!
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Stored_Procedure_Name')
BEGIN
PRINT 'Dropping Procedure Stored_Procedure_Name'
DROP Procedure Stored_Procedure_Name
END
GO
PRINT 'Creating Procedure Stored_Procedure_Name'
GO
CREATE Procedure Stored_Procedure_Name
/* Param List */
AS
/******************************************************************************
** File:
** Name: Stored_Procedure_Name
** Desc:
**
** This template can be customized:
**
** Return values:
**
** Called by:
**
** Parameters:
** Input Output
** ---------- -----------
**
** Auth:
** Date:
*******************************************************************************
** Change History
*******************************************************************************
** Date: Author: Description:
** -------- -------- -------------------------------------------
**
*******************************************************************************/
GO
GRANT EXEC ON Stored_Procedure_Name TO PUBLIC
GO