Coding Standards

Technical Article

Enhance your database development by using coding standards

  • DatabaseWeekly

Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.

You rated this post out of 5. Change rating

2019-05-21

External Article

Transact-SQL Formatting Standards

  • Article

How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How should lists be lined up? SQL is one of those languages that will execute however you treat whitespace and capitalization. However, the way SQL is laid out will effect its readability and the time taken to review and understand it. Standardisation of code layout is an important issue, but what standard should you adopt? Rob avoids a direct answer, but tells you the sort of answers you'll need to decide upon when creating a strategy for formatting SQL code.

2009-09-09

4,890 reads

Blogs

T-SQL Tuesday #186–Agent Jobs

By

It’s that time of the month again, when the T-SQL Tuesday blog party takes...

T-SQL Tuesday #186 - Agent Job History Visualization

By

I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....

KDA: Echoes of Deception - Case 2

By

The people of Digitown are being targeted by phishermen, and they need my help...

Read the latest Blogs

Forums

Execution Plan Operators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Execution Plan Operators

Just To Talk – Your Safe Space for Online Therapy

By jfrankline378

Welcome to Just To Talk, your trusted platform for compassionate, confidential online therapy. At...

Merge spans with Dates Logic

By dhanekulakalyan

--for a given member if the startdate and endate is continous we need to...

Visit the forum

Question of the Day

Execution Plan Operators

When looking at an execution plan in SSMS, what types of operators are shown?

See possible answers