SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[9.5.469 PRO] Line break after JOIN

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[9.5.469 PRO] Line break after JOIN
Author Message
Lesmian



Joined: 22 May 2018
Posts: 1
Country: Poland

Post [9.5.469 PRO] Line break after JOIN Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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

Code:
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.