-
Notifications
You must be signed in to change notification settings - Fork 13
Select list
Tako Lee edited this page Feb 26, 2014
·
44 revisions
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;
-
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;