SA 10 Beta issue - Code formatting has issue

I tried to format the following query with default formatting in SSMS 2014.

	Code:
	SELECT c.CustomerID, c.PersonID, c.StoreID, c.AccountNumber FROM sales.Customer AS c

It formatted like this.

	Code:
	/************************************************************ * Code formatted by SoftTree SQL Assistant © v10.0.158 * Time: 8/22/2018 3:17:15 PM ************************************************************/ SELECT c.CustomerID ,.c.PersonID ,.c.StoreID ,.c.AccountNumber FROM sales.Customer AS c

which is not right. it appends a dot before column name (like ".c.PersionID")

It looks like a problem with your customized formatting rules. One thing is known for sure, commas first is not a default format. It had to be customized to look like that. Please see if you got extra dots in your formatting rules.

Last edited by SysOp on Thu Aug 23, 2018 4:22 pm; edited 1 time in total

I don't see any problem in default formatting options. i did not modify any formatting option. Not sure where it is picking from.

The factory default code formatting rule for SELECT for SQL Server is very different from the screenshot. What I see in your screenshot is very likely syntaxically incorrect.

I recommend reloading default options. In the Options dialog click Import/Export button, then select Load Default Options and then click Import, and OK. Hope that fixes the issue for you.

But this is the format i am using since log time though. it worked in other versions of SA

I cannot say why it worked before. In ... ..., pattern something is missing either it should be changed to simple ..., or some keyword inserted, maybe ... AS ...,
Based on what you format, I think you wont the former, just a simple ...,