Settings and activity
4 results found
-
2 votes
Niels van de Coevering shared this idea ·
-
2 votes
-
30 votes
An error occurred while saving the comment -
10 votes
An error occurred while saving the comment Yes, suggesting the same
Here's an example query. When enabling the "Align aliases" option under "Lists", the aliases for tables are also aligned, which causes the table aliases to move away to the right from the tables.
SELECT
column1 = GETDATE()
,column2withlongname = HOST_ID()
FROM
sys.all_views [av]
INNER JOIN information_schema.views [v]
ON [v].table_name = av.name
INNER JOIN information_schema.view_column_usage [vcu]
ON [vcu].view_name = av.name;
This would be a great addition. My code is now formatted like beneath (underscores meant to be spaces), where the ORDER BY clause is creating a new line and I want an option to keep the OVER clause on one line.
SELECT
____ROW_NUMBER() OVER (PARTITION BY [Column1]
ORDER BY [Column1] ASC
_____________________________) AS Key
____,[Column2]