if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
CREATE PROCEDURE sp1....
END在查询分析器里执行这个的时候,说 PROCEDURE 附近有语法错误。为何?
BEGIN
CREATE PROCEDURE sp1....
END在查询分析器里执行这个的时候,说 PROCEDURE 附近有语法错误。为何?
DROP PROCEDURE sp1
create PROCEDURE sp1....
drop procedure sp1
goCREATE PROCEDURE sp1
as
select 1 from syscolumns
go drop procedure sp1
go
create proc ...
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp1]
Drop Proc ProcName
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('P_BA_AutoInvCode') AND TYPE = 'P')
BEGIN
DROP PROCEDURE P_BA_AutoInvCode
END
GO
CREATE PROCEDURE P_BA_AutoInvCode(
@as_PreFix NVARCHAR(32),
@as_InvCode NVARCHAR(32) OUTPUT
)
AS
/**********************************************************************************************************************
DESC:自动产生存货编码
AUTH:ROBI
**********************************************************************************************************************/
BEGIN
....
END