Clever Geek Handbook

How do you manage and organize your stored procedures?

How do you organize your stored procedures so that you can easily find them and keep track of their dependencies?

+1


source to share


3 answers


I tend to call them by convention. Usually {TableName} _ {operation} {extra}, where the extra part is optional.



For example: Product_Get, Product_Add, Product_Delete, Product_Update, Product_GetByName

+1


source


I am strongly considering creating database projects so that I can modify stored procedures and avoid confusion when deploying from development to production. Once they start syncing with a large project, things can get tricky.



0


source


I'm trying to keep the name as close as possible to what sp does. For example sp_Get *, sp_Set *, sp_Rep * etc. Although sp_ is super dense in a certain context, but due to the lack of source control integration (my pet) in Sybase, I use this nomenclature to keep track of them in my preferred source code control repository.

0


source






More articles:


All Articles