Select list

All items in a single line if possible

format option: fmt0001_select_list_in_newline, type: TFmtBoolean value: 0

• select list in the same line as SELECT keyword

  SELECT Name, ProductNumber, ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• select list in a newline

  SELECT 
    Name, ProductNumber, ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

Stacked select list

• First select list item in the same line as SELECT keyword

• comma after list item

  SELECT Name, 
         ProductNumber, 
         ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• comma before list item, first item align with comma

  SELECT Name
         ,ProductNumber
         ,ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• comma before list item, first item align with following items

  SELECT Name
        ,ProductNumber
        ,ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• comma before list item, first item align with following item, space between comma and list item is 1 or n

  SELECT Name
       , ProductNumber
       , ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• First select list item in new line

• comma after list item

  SELECT 
    Name, 
    ProductNumber, 
    ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• comma before list item, first item align with comma

  SELECT 
    Name
    ,ProductNumber
    ,ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• comma before list item, first item align with following items

  SELECT 
    Name
   ,ProductNumber
   ,ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;

• comma before list item, first item align with following items, space between comma and list item is 1 or n

  SELECT 
    Name
  , ProductNumber
  , ListPrice AS Price
  FROM Production.Product 
  ORDER BY Name ASC;