Click here to Skip to main content
12,404,278 members (72,710 online)
Click here to Skip to main content
Add your own
alternative version

Stats

72.8K views
1.7K downloads
34 bookmarked
Posted

T-SQL Coding Standard

, 1 Oct 2008 CPOL
Rate this:
Please Sign up or sign in to vote.
T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)

Introduction

I am currently working on a T-SQL coding standard to formalize our work. Having been inspired by the IDesign C# Coding Standard, I made this T-SQL Coding Standard Document. Maybe this will have some value for the community. It is work in progress and I intend to update it as my experience with its implementation continues.

Unfortunately, I wrote the document in Word using loads of formatting and CodeProject's editor cannot display the document directly. Instead, I leave the document here in a zip for download.

When the document has matured some more, I will reformat it in HTML and modify this article.

Casper Leon Nielsen - 21. Sep 2006. (modified 1st October 2008)

License

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

Share

About the Author

Casper Leon Nielsen
Architect HelloGroup
Denmark Denmark
Casper Leon Nielsen is a MCP/MCAD and is currently employed by HelloGroup a/s - a technical savy (yes that whats they are calling it these days) company.

You may also be interested in...

Comments and Discussions

 
GeneralRe: NOLOCK? Pin
Rhodesie1-Oct-06 22:59
memberRhodesie1-Oct-06 22:59 
Answerderived tables Pin
Casper Leon Nielsen28-Sep-06 23:15
memberCasper Leon Nielsen28-Sep-06 23:15 
GeneralDiscussion on joelonsoftware Pin
Casper Leon Nielsen24-Sep-06 10:50
memberCasper Leon Nielsen24-Sep-06 10:50 
Generalprefixing stored procedures with sp_ is bad practice Pin
KinStephen21-Sep-06 13:13
memberKinStephen21-Sep-06 13:13 
Your coding standard says to prefix all stored procedures with "sp_". There is numerous article recommding this is bad practice as SQL Server will scan for system stored procedures prefixed with sp and then look for your stored procedure (this is an optimization issue). It would be best if you prefixed the stored procedure with something such as "usp_".


AnswerAnd the standard says you shouldnt Pin
Casper Leon Nielsen21-Sep-06 20:53
memberCasper Leon Nielsen21-Sep-06 20:53 
GeneralRe: And the standard says you shouldnt Pin
KinStephen22-Sep-06 7:21
memberKinStephen22-Sep-06 7:21 
AnswerConclusion [modified] Pin
Casper Leon Nielsen22-Sep-06 8:33
memberCasper Leon Nielsen22-Sep-06 8:33 
GeneralRe: Conclusion Pin
KinStephen22-Sep-06 11:28
memberKinStephen22-Sep-06 11:28 
GeneralWhy not... Pin
Colin Angus Mackay21-Sep-06 3:41
memberColin Angus Mackay21-Sep-06 3:41 
AnswerRe: Why not... Pin
Casper Leon Nielsen21-Sep-06 3:57
memberCasper Leon Nielsen21-Sep-06 3:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.160721.1 | Last Updated 1 Oct 2008
Article Copyright 2006 by Casper Leon Nielsen
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid