1、判断存储过程是否存在,存在就删除,并重新创建。
IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'ProcedureName') and OBJECTPROPERTY(id, N'IsProcedure')=1)
DROP PROCEDURE [dbo].[ProcedureName]
GO
CREATE PROCEDURE ProcedureName
AS
-- 你的查询语句
GO
1、判断存储过程是否存在,存在就删除,并重新创建。
IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'ProcedureName') and OBJECTPROPERTY(id, N'IsProcedure')=1)
DROP PROCEDURE [dbo].[ProcedureName]
GO
CREATE PROCEDURE ProcedureName
AS
-- 你的查询语句
GO