Stored Procedure Naming Conventions

  • shobin-1086015

    SSC Rookie

    Points: 43

    I suggest not to make use of any prefixes.

    Just we can use Sel_User or User_Sel

    This will no cause any performance issue as we are not using sp_.

    Also it will help us to search the SP if we have a large number of SPs say 500.

    If we want to make a change to user details section of our application. all SPs related to a table can be sorted out easily by starting alphabet. from there we can get the select or Get sp

  • nishad.jadhav

    SSC Enthusiast

    Points: 106

    Hi,

    Any suggestions on how one can name SPs which update different columns of a same table, based on diffrenet conditions?

    Thanks!

  • sushila

    SSC-Dedicated

    Points: 35293

    Something that uses "multiple columns", "multiple conditions" in any abbreviated form/combination that you may find makes sense in your environment?! :unsure:

    I would tend to stick as closely as possible to the purpose of the procedure without having to make it into a long sentence.







    **ASCII stupid question, get a stupid ANSI !!!**

  • nishad.jadhav

    SSC Enthusiast

    Points: 106

    Thanks!:-)

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply