WHERE-clause alignments

• 
  Hi GHauan,
  
  Thanks for the suggestion. You can insert code tags on here to keep your text formatted.
  
  Could I confirm you want to style your code like this? Are you using the new formatting options (enabled in experimental features)?
  

  SELECT *
  FROM dbo.Anlegg
  WHERE AnleggsId = 1
    AND StartDate <= getdate()
    AND StopDate IS NULL;
  

  
  Best wishes,
  
  Michael Clark
  Technical Lead, SQL Prompt

  Michael Clark April 25, 2017 15:20

  - 0 +
• 
  Hi Michael
  
  The way I want it to be, is the way it is in my original post. Meaning that the AND start on same column as the WHERE:
  

  SELECT *
  FROM dbo.Anlegg
  WHERE Anleggsid = 1
  AND StartDate <= getdate()
  AND StopDate IS NULL;
  

  
  I have not tried the experimental features.
  
  The way it is formatted today is like this (and this is not how I want it):

  SELECT *
  FROM dbo.Anlegg
  WHERE 	Anleggsid = 1
         AND StartDate <= getdate()
         AND StopDate IS NULL;
  

  GHauan April 26, 2017 11:31

  - 0 +
• 
  Hi GHauan,
  
  We support the style you want as default with our new formatting styles.
  
  You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting styles"
  
  Please let us know if you have any trouble
  
  Thanks,
  Michael

  Michael Clark April 26, 2017 12:57

  - 0 +
• 
  Hello guys,

  
  

  I am using SQL Prompt 9.2.2 and the alignment of the where clause as GHauan had commented is not yet available.

  
  

  In version 9.2.2, I tried to enable the option "SQL Prompt> Options ...> Labs> Experimental Features> Use new formatting styles" as Michael commented, but does not have this option.

  
  

  Do you have any idea when this option will be implemented?
  
  Example
  
  

  select *

  from table

  where condition1 = 1

      and condition2 = 2

  
  

  Thank you
  
  
  

  tiago_pimenta October 18, 2018 13:01

  - 0 +
• 
  I am trying to setup my style using 10.0.6 and can't seem to get the AND to line up with the WHERE.  What setting would I use to get the following:
  
  SELECT *
  FROM table AS t
  WHERE t.col1=1
  AND t.col2=2;
  
  I had it before, but had to rebuild my machine and lost my old style. 
  
  

  LarryBoynton January 02, 2020 21:18

  - 0 +

Add comment

Please sign in to leave a comment.