Stored Procedures Naming
In this post we will see how to make good / ease to understand stored procedure.
Suppose you are having XYZ_Products table in your database where XYZ is the name of Data Base.
How to name the Insert Procedure written for New product insert ?
|Create Procedure XYZ_Products_Insert
, @CreateDate DataTime
Insert Into XYZ_Products(ProductName,CreateDate)
How we had named it ? We have taken Name of the Table then suffixed this name with operation that we are performing, In this case its Insert operation.
The common practice is NameOfTheTable_OperationName