Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Naming my SPs
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Naming my SPs
Divers
Thread ID:
01096226
Message ID:
01096226
Vues:
58
Is there a negative side-effect of using the following 3 characters sp_ in the beginning of my custom SP name? (as long as I am 99.9% sure that the server doesn't have a built-in SP with the same name)

I currently use the following naming convention for my SPs: sp_als_[tablename]_[U|I|UI|S|D]

I came accross a website that recomended not starting my custom SPs with sp_ (and it referenced BOL, but I couldn't find it in BOL). The website stated that if the SP name started with sp_ the server would always look through the built in SPs before looking through DBO SPs. I guess this could be prevented by always calling the SP using the full name i.e. dbo.sp_als_TblName_S

Einar
Semper ubi sub ubi.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform