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

Tagged as

DEVELOPMENT AND CODING STANDARDS: SQL and Database Guidelines

, 19 Mar 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
DEVELOPMENT AND CODING STANDARDS: SQL and Database Guidelines
  1. SQL AND DATABASE RULES
    1. NAMING CONVENTIONS
    2. DECLARING VARIABLES
    3. SELECT STATEMENTS
    4. CURSORS
    5. WILDCARD CHARACTERS
    6. NOT EQUAL OPERATORS
    7. DERIVED TABLES
    8. SQL BATCHES
    9. ANSI-STANDARD JOIN CLAUSES
    10. STORED PROCEDURES NAMING CONVENTION
    11. USING VIEWS
    12. TEXT DATA TYPES
    13. INSERT STATEMENTS
    14. ACCESSING TABLES
    15. STORED PROCEDURE RETURNING VALUES
    16. OBJECT CASE
    17. T-SQL VARIABLES
    18. OFFLOAD TASKS
    19. CHECK FOR RECORD EXISTENCE
    20. OBJECT OWNER
    21. UPSERT STATEMENTS
    22. DATETIME COLUMNS
    23. MEASURE QUERY PERFORMANCE
    24. 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)

Share

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 22:18 
Questiongood PinmemberHua Yujun1-Apr-13 21:20 
Questiongood PinmemberHua Yujun1-Apr-13 20: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 | Terms of Use | Mobile
Web03 | 2.8.150331.1 | Last Updated 20 Mar 2011
Article Copyright 2011 by Ali Tarhini
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid