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_StudentStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Get_StudentStatus]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Get_TeacherList Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_TeacherList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Get_TeacherList]
GO
/****** Object: Stored Procedure dbo.CourseSystem_Get_TeacherStatus Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_TeacherStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_Get_TeacherStatus]
GO
/****** Object: Stored Procedure dbo.CourseSystem_List_Courses Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_List_Courses]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_List_Courses]
GO
/****** Object: Stored Procedure dbo.CourseSystem_List_Teacher Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_List_Teacher]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CourseSystem_List_Teacher]
GO
/****** Object: Stored Procedure dbo.Help_Get_HelpFile Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Help_Get_HelpFile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Help_Get_HelpFile]
GO
/****** Object: Stored Procedure dbo.Login_Get_Role Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_Role]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Login_Get_Role]
GO
/****** Object: Stored Procedure dbo.Login_Get_Roles Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_Roles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Login_Get_Roles]
GO
/****** Object: Stored Procedure dbo.Login_Get_Task Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_Task]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Login_Get_Task]
GO
/****** Object: Stored Procedure dbo.Login_Get_UserView Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_UserView]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Login_Get_UserView]
GO
/****** Object: Stored Procedure dbo.Login_Verify_Password Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Verify_Password]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Login_Verify_Password]
GO
/****** Object: Stored Procedure dbo.Login_Verify_PasswordNull Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Verify_PasswordNull]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Login_Verify_PasswordNull]
GO
/****** Object: Stored Procedure dbo.Member_Add_Student Script Date: 2003-5-31 17:34:09 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_Add_Student]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_Add_Student]
GO
/****** Object: Stored Procedure
评论0