Hi @Bobby P ,
If you prefer using underscores ,you can keep it .
My advice to you is adding prefix to calrify what type the procedure is .
Prefix :
gen - General: CRUD, mostly
rpt - Report: self-explanatory
tsk - Task: usually something with procedural logic, run via scheduled jobs
For example:
genInsOrderHeader
genSelCustomerByCustomerID
genSelCustomersBySaleDate
genUpdCommentText
genDelOrderDetailLine
rptSelCustomersByState
rptSelPaymentsByYear
tskQueueAccountsForCollection
For more information,please refer to:https://stackoverflow.com/questions/238267/what-is-your-naming-convention-for-stored-procedures
Best Regards,
Isabella
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.