Code formatting

External Article

Laying out SQL Code

  • Article

It is important to ensure that SQL code is laid out the best way for the team that has to use and maintain it. Before you work out how to enforce a standard, one has to work out what that standard should be for the application. So do you dive into detail or create an overall logic to the way it is done?

2010-02-05

4,843 reads

External Article

Transact-SQL Formatting Standards (Coding Styles)

  • 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 anyway 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-08

4,913 reads

Blogs

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

By

They run, they return data. So what? Some SQL queries just waste your time...

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

Read the latest Blogs

Forums

Question about updating statistics

By SQL Guy 1

We have very large tables in our database, some even more 1 B records,...

Greener Grass

By Grant Fritchey

Comments posted to this topic are about the item Greener Grass

What tool or tools do people like for monitoring SQL servers?

By tschgc

I have a few tools at my disposal but none of them seems like...

Visit the forum

Question of the Day

A Basic Data API Builder ADD

What parameters are required for the dab add command in the Data API Builder?

See possible answers