Table of Contents

1. Naming Conventions
2. Locking
3. Selecting
4. Permissions

example: usp_API_RecordListGet

1. type

• usp (user stored proc)
• udf (user definted function)

2. app

• API
• SSIS
• AM (admin)
• DJC (djcity.com)

3. function (What the function is for and what the function does. see below examples)

• RecordListGet
• RecordDetailUpdate
• RecordDetailGet
• RecordDetailInsert
• CustomerAPIPasswordGet
• etc...

• Instead of using “with nolock” on each table, you can just put this in the beginning of the stored procedure and it applies nolock to all tables in that proc: set transaction isolation level read uncommitted

• Please don’t use “select * from …“. Always specify the column names “select rid, title, name from …“.

• Please don’t give any select permission to users on tables. Users should only have permission on execute for stored procedures and if necessary, some functions.