Insert empty line between join clauses
torsten.strauss
Posts: 271 Silver 3
Hi Redgate Team,
The following statement will cause a formatting issue:
SELECT 1
FROM
sys.dm_exec_requests AS r
INNER JOIN
sys.dm_exec_sessions AS se
ON
r.session_id = se.session_id
FULL OUTER JOIN
sys.dm_exec_connections AS con
ON
con.session_id = se.session_id
OUTER APPLY sys.dm_exec_query_plan(plan_handle) AS p
OUTER APPLY sys.dm_exec_sql_text(r.plan_handle) AS t
GO
If you enable JOIN / Insert empty line between join clauses SQL Prompt will just add a new line before the FULL OUTER JOIN. I expected to see a new line for every join clause.
I guess this needs to be fixed...
Thanks!
Torsten
The following statement will cause a formatting issue:
SELECT 1
FROM
sys.dm_exec_requests AS r
INNER JOIN
sys.dm_exec_sessions AS se
ON
r.session_id = se.session_id
FULL OUTER JOIN
sys.dm_exec_connections AS con
ON
con.session_id = se.session_id
OUTER APPLY sys.dm_exec_query_plan(plan_handle) AS p
OUTER APPLY sys.dm_exec_sql_text(r.plan_handle) AS t
GO
If you enable JOIN / Insert empty line between join clauses SQL Prompt will just add a new line before the FULL OUTER JOIN. I expected to see a new line for every join clause.
I guess this needs to be fixed...
Thanks!
Torsten
Tagged:
Comments
Thank you for reporting, but we don't think it is a bug. This option does what it says, it adds new line between JOIN clauses, not before each JOIN. It is well presented on default preview in Prompt.
Best regards,
Krzysztof Kroczak