Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
A quick MSFT SQL Question
I am trying to check for the existance of a procedure and if it exists I want to alter it. If not I want to create it. When I place this code in the Query Analyzer of MSFT I get an error saying there is a problem near Procedure in line 2. Does anyone know why?
If I delete all lines except for the IF and add in a DROP PROCEDURE prGetEqId it works. If I just put in the Alter Procedure it works.
If I put in a BEGIN/END after the IF I get an error.
Thanks for any assistance in advance.
Jim
HERE IS THE CODE:
IF exists(select * from sysobjects where id = object_id('prGetEqId') and OBJECTPROPERTY(id,'IsProcedure')=1)
Alter Procedure prGetEqId
@Make varchar(50),
@Model varchar(50)
as
SELECT EquipmentId
FROM Equipment
WHERE Make = @Make
and Model = @Model
ELSE
Create Procedure prGetEqId
@Make varchar(50),
@Model varchar(50)
as
SELECT EquipmentId
FROM Equipment
WHERE Make = @Make
and Model = @Model
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement