摘要:
1、判断是否存在addOneArticle这个存储过程if Exists(select name from sysobjects where NAME = 'addOneArticle' and type='P')drop procedure addOneArticle2、判断是否存在countAr这个触发器if exists(select * from dbo.sysobjects where id = object_id(N'[dbo].[countAr]') and OBJECTPROPERTY(id, N'IsTrigger 阅读全文