1 / 8

T-SQL... Interactive Coding Standards

T-SQL... Interactive Coding Standards. Session Overview. What are coding standards? Why do we need them? Quick list of standards The interactive bit… show us your brains!. What are coding standards?.

fawn
Download Presentation

T-SQL... Interactive Coding Standards

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. T-SQL... Interactive Coding Standards

  2. Session Overview • What are coding standards? • Why do we need them? • Quick list of standards • The interactive bit… show us your brains!

  3. What are coding standards? A set of rules that tells developers in a team how to write their code, instead of each developer coding in their own preferred style. A set of rules that tells developers in a team how to write their code, instead of each developer coding in their own preferred style.

  4. Why do we need coding standards? A set of rules that tells developers in a team how to write their code, instead of each developer coding in their own preferred style. Maintainable Code

  5. A few standards to whet your appetite • CAPITALISE keywords • Indent your code • Comments, comments & more comments • Do not call functions repeatedly • No anonymous inserts • Don’t use select * • Avoid using not equals operators • Don’t use hardcoded values • Catch errors

  6. Ideas time....

  7. Resources A set of coding standards will be made available to download from my blog. • Blog: http://nzgirlgeek.blogspot.com • E-mail: amanda.jackson@fronde.co.nz Websites that have helped me in my search for coding standards nirvana… • http://www.sqlserver.org.au/ • http://www.cslacey.co.uk/TSQLCodingStandards.pdf • http://www.pinaldave.com/sql-download/SQLServerGuideLines.pdf • http://www.sql-server-performance.com/articles/dev/sql_best_practices_p1.aspx • http://www.sqlserver.org.au/

  8. Thank you.

More Related