【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了createprocedure.sql提供大家参考,希望对大家有所帮助!
use park
go
/****** Object: Stored Procedure dbo.Check_Content_Right Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Check_Content_Right]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Check_Content_Right]
GO
/****** Object: Stored Procedure dbo.ClassSystem_Change_ClassStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_Change_ClassStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassSystem_Change_ClassStatus]
GO
/****** Object: Stored Procedure dbo.ClassSystem_Delete_Class Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_Delete_Class]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassSystem_Delete_Class]
GO
/****** Object: Stored Procedure dbo.ClassSystem_Get_ClassStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_Get_ClassStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassSystem_Get_ClassStatus]
GO
/****** Object: Stored Procedure dbo.ClassSystem_List_Classes Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_List_Classes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassSystem_List_Classes]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Add_Course Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Add_Course]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Add_Course]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Add_Teacher Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Add_Teacher]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Add_Teacher]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Change_CourseStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Change_CourseStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Change_CourseStatus]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Change_StudentStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Change_StudentStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Change_StudentStatus]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Change_TeacherStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Change_TeacherStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Change_TeacherStatus]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Delete_Course Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Delete_Course]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Delete_Course]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Delete_Teacher Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Delete_Teacher]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Delete_Teacher]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Get_CourseStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_CourseStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Get_CourseStatus]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Get_StudentStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_StudentSta