Post reply

Stored Procedure Naming Conventions

  • March 19, 2010 at 3:20 am

    #1136539

    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

  • February 13, 2012 at 3:18 am

    #1446139

    Hi,

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

    Thanks!

  • February 13, 2012 at 7:33 am

    #1446233

    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 !!!**

  • February 13, 2012 at 8:21 am

    #1446274

    Thanks!:-)

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

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