You're not really supposed to be seeing this.. site is a work in progress.. but feel free to bookmark lert.us and come back later!

SQL Formatting Guide

eilert - 1900-01-01 00:00:00.00

Why format SQL?

Readability of code is essential for maintaining code.

It's a Preference

There isn't really a standard for formatting SQL. And if there were, I might not like it, because it might not match my style.
I really think each person's preference might be in a way that helps them read the SQL and may be different for each individual.

Aliasing

Interestingly, people can get quite passionate here. I'm not one of those person, but my preference is a simple "A", "B", "C" approach to aliasing tables.

I also don't use AS

I suppose I write so many queries I don't care to take the time to think through a useful

About Me

Image

I've been working with SQL Server for the last 12 years and have found it to be a marvelous data platform. I love writing SQL and sharing my knowledge.

Follow Me

Some text..