 <p>If I am making changes to already written T-SQL, then I follow the already used convention (if there is one). </p> <p>If I am writing from scratch or there is no convention, then I tend to follow your convention given in the question, except I prefer to use capital letters for keywords (just a personal preference for readability). </p> <p>I think with SQL formatting as with other code format conventions, the important point is to have a convention, not what that convention is (within the realms of common sense of course!)</p>