Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking If A Proc Exists
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Checking If A Proc Exists
Divers
Thread ID:
01245040
Message ID:
01245040
Vues:
66
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....
What am I doing wrong here?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform