books_uninstall.sql

来自「Books source code for Rainbow Portal」· SQL 代码 · 共 31 行

/* Un-Install script, Books Module, Last Updated 9/25/03 */
/* Problems, comments.  Chris Farrell, [e-mail]*/
/* based upon Wrox press ASP.Net "Building an ASP.Net Intranet", ch3*/

USE [Rainbow]
GO

/*DO NOT DROP TABLE!!!!!!*/

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_AddBook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_AddBook]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_DeleteBook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_DeleteBook]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_GetBooks]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_GetBooks]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_GetSingleBook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_GetSingleBook]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[rb_UpdateBook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [rb_UpdateBook]
GO