SQLinForm SQL FormatterCommunity Discussion Forum
SQLinForm SQL Formatter
You can see from my sample below, I do not want a new line after "WHERE(" and I do not want "ON" to align. I also noticed the SELECT fields do not align in the sub select. Is this configurable??
LEFT OUTER JOIN ( SELECT ModuleID,
UserDefined3,
OwnerID
FROM AdditionalInfo AS AdditionalInfo_2
WHERE(
ModuleID = 12) ) AS Finish ON Items.ItemID = Finish.OwnerID
LEFT OUTER JOIN InventoryTracking ON Items.InventoryTrackingID = InventoryTracking.InventoryTrackingID
LEFT OUTER JOIN Categories ON Items.CategoryID = Categories.CategoryID
It should look like this:
LEFT OUTER JOIN (SELECT ModuleID,
UserDefined3,
OwnerID
FROM AdditionalInfo AS AdditionalInfo_2
WHERE(ModuleID = 12)
) AS Finish ON Items.ItemID = Finish.OwnerID
LEFT OUTER JOIN InventoryTracking ON Items.InventoryTrackingID = InventoryTracking.InventoryTrackingID
LEFT OUTER JOIN Categories ON Items.CategoryID = Categories.CategoryID
Hi @itsnota2ma,
Question 1:you can avoid a new line after "WHERE(" be unchecking the linebreaks for condition brackets
Question 2: You cannot avoid the alignment of the on if the "on" has no linebreak before
Question 3: here you have 2 options
Option 1: put a linebreak after the sub-select open bracket and the SELECT will be moved to its correct position
Option2 (recommended): In the new Release there is a new option for Sub-selects called "Align Sub-Select to Open Bracket"
Hope this helps
Well, this explains a few things. I do not have those options and when I open from SSMS, this is what I get. And I just installed the latest version for SSMS 22. I was pointing to the old desktop version. I see the plugin in SSMS, which does not have those options, and I cannot find the executable for the desktop version once I removed the SSMS 21 version.
Okay, I just downloaded the Portable App and I see the changes I can make.
Hi @itsnota2ma,
in the ssms plugin there is a tab for subselect options and a tab for Condition Options
Guido,
Where are the profiles stored for the SSMS plugin? Can it be changed?
Thanks,
Mike
Hi MIke, the Team Folder Location can be changed into a shared folder for the whole team
