Comments
Sort by recent activity
A little more information.
When "Qualify Object Names" is turned off, the period is not removed, but the tab is still inserted after the period following the table alias and column name.
Kurt / comments
A little more information.
When "Qualify Object Names" is turned off, the period is not removed, but the tab is still inserted after the period following the table alias and column name.
Kurt
I have the same problem.
The first time during the format it looks like a tab is inserted between the alias and the column . Surprisingly SQL does not balk at this and the code still works.
The second time the source is formatted, the period "." after the alias is removed. The code no longer works after this.
Some added information:
Seems like this only happens if the alias is a single character, changing the alias to multiple characters as a work around prevents this from happening.
Turning off "Qualify Object Names" prevents this problem as well.
Hopefully this information assists in resolving this problem.
Thanks,
Kurt
I am running SQL Prompt 9.07.3692
SSMS Version
Microsoft SQL Server Management Studio 12.0.2569.0
Microsoft Analysis Services Client Tools 12.0.2569.0
Microsoft Data Access Components (MDAC) 10.0.16299.15
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.16299.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.16299 / comments
I have the same problem.
The first time during the format it looks like a tab is inserted between the alias and the column . Surprisingly SQL does not balk at this and the code still works.
The sec...
@Matthew_Sontum Try changing your alias to multiple characters from a single character. This workaround has been working for me.
K / comments
@Matthew_Sontum Try changing your alias to multiple characters from a single character. This workaround has been working for me.
K