>>I am sure this question has been asked a million times. And yet I am asking it again. I see everywhere online stored procedures named with prefix sp (e.g. sp_custom_account). Is there a technical or a logical reason for that? Since stored procedures are in SQL DB Programmability -> Stored Procedures, why need to tag them as SP still?
>
>There is no particular reason, other than whne looking at the name that you can identify its a stored procedure.
>Since we are not a heavy user of stored procedures we do not use any naming convention for stored procedures.
My app is not a heavy use of stored procedures either. But I would like to have consistency in my sp names (which I don't, unfortunately).
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham