 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Lesmian
Joined: 22 May 2018 Posts: 1 Country: Poland |
|
[9.5.469 PRO] Line break after JOIN |
|
Hi, is there any way to prevent line break when I pick join statemant from SQL Assistant hint popup?
What I get now is:
SELECT TOP 1000 *
FROM dbo.TEST T
JOIN dbo.TEST2 T2
ON T2.ID = T.ID
What I want is:
SELECT TOP 1000 *
FROM dbo.TEST T
JOIN dbo.TEST2 T2 ON T2.ID = T.ID
I've already configured formatting and when I use it it format SQL correctly. What I want is to format it when I pick JOIN hint.
|
|
Tue May 22, 2018 3:15 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Please use your custom formatting rule/style (press Ctrl+F11) to reformat code. The default layout is designed for most common use, typically multiple columns and expression in the JOIN clause, something like
 |
 |
SELECT TOP 1000 trm.*
FROM dbo.TEST_long_or_not_so_long_name AS trn
JOIN dbo.TEST2_another_long_name AS t2rm
ON t2rn.ID = trn.ID
AND t2rn,second_column_here <trnm> CURRENT_TIMESTAMP - 30 |
|
|
Tue May 29, 2018 9:58 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|