Select list

Jump to bottom Edit New page

Tako Lee edited this page Feb 26, 2014 · 44 revisions

All items in a single line if possible

Option: fmt001_select_list_style = fit_into_one_line, type: TFmtListStyle.

select list in the same line as SELECT keyword

Option: fmt002_select_list_in_newline = false, type: TFmtBoolean.

Option: fmt003_select_list_comma_option = after_item_with_1_space, type: TFmtCommaOption.
```
SELECT Name, ProductNumber, ListPrice AS Price
FROM Production.Product 
ORDER BY Name ASC;
```

select list in a newline

Option: fmt002_select_list_in_newline = true, type: TFmtBoolean.

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

Stacked select list

Option: fmt001_select_list_style = stacked, type: TFmtListStyle.

First select list item in the same line as SELECT keyword

comma after list item

Option: fmt003_select_list_comma_option = after_item, type: TFmtCommaOption.

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

comma before list item, first item align with comma

Option: fmt003_select_list_comma_option = before_item_inside_list, type: TFmtCommaOption.
```
SELECT Name
       ,ProductNumber
       ,ListPrice AS Price
FROM Production.Product 
ORDER BY Name ASC;
```
comma before list item, first item align with following items

Option: fmt003_select_list_comma_option = before_item_outside_list, type: TFmtCommaOption.
```
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

Option: fmt003_select_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

Option: fmt004_select_list_comma_space = n, type: int.
```
SELECT Name
     , ProductNumber
     , ListPrice AS Price
FROM Production.Product 
ORDER BY Name ASC;
```
First select list item in new line

Option: fmt008_select_list_indent = n, type: int.

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;

PP V3 format options