摘要： 查询分析器执行use dbname if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[changename]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[changename] GO SET QUOTED_IDENTI... 阅读全文