Click here to Skip to main content
Click here to Skip to main content

DEVELOPMENT AND CODING STANDARDS: SQL and Database Guidelines

, 19 Mar 2011
Rate this:
Please Sign up or sign in to vote.
DEVELOPMENT AND CODING STANDARDS: SQL and Database Guidelines
1. SQL AND DATABASE RULES
2. NAMING CONVENTIONS
3. DECLARING VARIABLES
4. SELECT STATEMENTS
5. CURSORS
6. WILDCARD CHARACTERS
7. NOT EQUAL OPERATORS
8. DERIVED TABLES
9. SQL BATCHES
10. ANSI-STANDARD JOIN CLAUSES
11. STORED PROCEDURES NAMING CONVENTION
12. USING VIEWS
13. TEXT DATA TYPES
14. INSERT STATEMENTS
15. ACCESSING TABLES
16. STORED PROCEDURE RETURNING VALUES
17. OBJECT CASE
18. T-SQL VARIABLES
19. OFFLOAD TASKS
20. CHECK FOR RECORD EXISTENCE
21. OBJECT OWNER
22. UPSERT STATEMENTS
23. DATETIME COLUMNS
24. MEASURE QUERY PERFORMANCE
25. INDEXES
 
Description is here:
http://alitarhini.wordpress.com/2011/03/20/development-and-coding-standards-sql-and-database-guidelines/[^]

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Ali Tarhini
Software Developer (Senior) Microgen
Lebanon Lebanon
For more articles and extreme topics please check out my personal website www.alitarhini.com

Comments and Discussions

 
Questiongood PinmemberHua Yujun1-Apr-13 21:18 
Questiongood PinmemberHua Yujun1-Apr-13 20:20 
http://www.sql-server-performance.com/2001/sql-best-practices/2/
I like programing

Questiongood PinmemberHua Yujun1-Apr-13 19:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 20 Mar 2011
Article Copyright 2011 by Ali Tarhini
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid