参考:if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[databackup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[databackup]
GOCREATE proc dbo.databackup
as
declare @path varchar(50)
declare @filename varchar(60)
SET DATEFIRST 1
set @path='E:\database_bak\'
set @filename=@path+'OA_DB.bak'
backup database guide_OA to disk=@filename
GO
drop procedure [dbo].[databackup]
GOCREATE proc dbo.databackup
as
declare @path varchar(50)
declare @filename varchar(60)
SET DATEFIRST 1
set @path='E:\database_bak\'
set @filename=@path+'OA_DB.bak'
backup database guide_OA to disk=@filename
GO
drop procedure rStudent
gocreate procedure rStudent
as select * from Studentgoexec rStudentgo
go
if object_id('存储过程名','p')is not null
drop proc 存储过程名
create proc 存储过程名
as
select *
from 学生表
if exists(select * from sysobjects where name = '存储过程名称' and xtype = 'P')
drop procedure 存储过程名称
gocreate procedure 存储过程名称
as ...
if exists(select * from sys.procedures where name = '存储过程名称')
drop procedure 存储过程名称
gocreate procedure 存储过程名称
as ...
drop procedure proc_student
GO
create procedure student
as selct * from student
Go
exec proc_student
Go