CREATE PROCEDURE sp_ProcExists @SProcName nvarchar(100 AS IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(@SProcName) AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE @SProcName <=========== Errors here>Yes
>... @sproc nvarchar(100) >... >WHERE id = object_id(@sproc) >... >>>
>>>IF exists (SELECT * from dbo.sysobjects >>> WHERE id = object_id(N'dbo.sp_MyProc') >>> and OBJECTPROPERTY(id, N'IsProcedure') = 1) >>>>>>>I can't seem to get this syntax right:
>>>>USE SC >>>>GO >>>> >>>>IF EXISTS(SELECT * FROM SysObjects WHERE Id = "sp_MyProc") >>>> DROP PROCEDURE sp_MyProc >>>> >>>>GO >>>> >>>>CREATE PROC sp_MyProc.... >>>> >>>>>>>>