Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Option: Aligning on Aliases and Operators #64

Open
SauceTheBoss opened this issue May 24, 2012 · 1 comment
Open

Option: Aligning on Aliases and Operators #64

SauceTheBoss opened this issue May 24, 2012 · 1 comment

Comments

@SauceTheBoss
Copy link

I would love to have an option to align on 'AS' (for aliases) and operators like '=' (for Sets, Where clauses, and Join statements).

Example:

SELECT PatientDocs.PatientID AS PatientID,
       Patients.FirstName    AS PatientFirstName,
       Patients.LastName     AS PatientLastName,
       Patients.MiddleName   AS PatientMiddleName
FROM   PatientDocs
       LEFT JOIN Patients
         ON Patients.PatientID   = PatientDocs.PatientID
            AND Patients.AdmitID = PatientDocs.AdmitID
WHERE  PatientDocs.AdmitID     = 2
       AND PatientDocs.DocDate < GETDATE() 
@TaoK
Copy link
Owner

TaoK commented Sep 8, 2014

Simon Holzman requests the same type of thing for variable declarations:

DECLARE @somethingshort        INT,
        @something_really_long UNIQUEIDENTIFIER,
        @somethingelse         UNIQUEIDENTIFIER

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants