34,590
社区成员
发帖
与我相关
我的任务
分享
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PROC_statistics]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PROC_statistics]
GO
if object_id('存储过程名','p') is not null
drop proc 存储过程名
go
if exists
(select * from dbo.sysobjects where id = object_id(N'[dbo].[P_DECODER_Exists]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_DECODER_Exists]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_DECODER_Exists]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_DECODER_Exists]