Use the Wrapping section of the formatting options to setup wrapping rules for automatic code formatting. You can use the following options:
Wrap text when it exceeds right margin value
Select it to whap the typed text when it exceed the right margin value.
Set wrapping for SQL statements
Place comma before a list item (at the beginning of the line)
Select it to place comma before a list item (at the beginning of the line).
Stack "SELECT" list items
Select to line-up "SELECT" list items with the first one in "SELECT" statements.
Stack "GROUP BY" list items
Select to line-up "GROUP BY" list items with the first one in "SELECT" statements.
Stack "ORDER BY" list items
Select to line-up "ORDER BY" list items with the first one in "SELECT" statements.
Stack "SET" list items in "UPDATE"
Select to line-up "SET" list items with the first one in "UPDATE" statements.
Stack column list items in "INSERT"
Select to line-up column list items with the first one in "INSERT" statements.
Stack "VALUES" list items in "INSERT"
Select to line-up "VALUES" list items with the first one in "INSERT" statements.
Stack column list items in "CREATE VIEW"
Select to line-up "GROUP BY" list items with the first one in "SELECT" statements.
Stack expressions in "VALUES" list items in "INSERT"
Select to line-up expressions in "VALUES" list items with the first one in "INSERT" statements.
Set wrapping for parameter declaration
Leave parameters on single line
 Copy Code |
CREATE PROCEDURE getlist @product VARCHAR(40),
@maxprice MONEY,
@compareprice MONEY OUTPUT,
@listprice MONEY OUT
AS
BEGIN
...
END
|
Stack parameters
| Copy Code |
CREATE PROCEDURE getlist @product VARCHAR(40),
@maxprice MONEY,
@compareprice MONEY OUTPUT,
@listprice MONEY OUT
AS
BEGIN
...
END
|
Stack parameters if they exceed right margin value
| Copy Code |
CREATE PROCEDURE getlist @product VARCHAR(40),
@maxprice MONEY,
@compareprice MONEY OUTPUT,
@listprice MONEY OUT
AS
BEGIN
...
END
|
Set wrapping for variable declaration
Leave variables on single line
| Copy Code |
DECLARE @v INTEGER, @var VARCHAR, @variable INT
|
Stack variables
| Copy Code |
DECLARE @v INTEGER,
@var VARCHAR,
@variable VARBINARY
|
Stack variables if they exceed right margin value
| Copy Code |
DECLARE @v INTEGER,
@var VARCHAR,
@variable VARBINARY
|
Reset Page Defaults
Click this button to reset settings on this page to the default ones.
See Also