Comments
Sort by recent activity
Hi @Tianjiao_Li,
Today I've updated to version 9.1.1.4243 and it has been resolved. / comments
Hi @Tianjiao_Li,
Today I've updated to version 9.1.1.4243 and it has been resolved.
Hi @Tianjiao_Li,
With the default format style I don't have the issue.
So it seems to be in one of the settings in our company style.
I'll attach our company style.
With these settings I have the problem. / comments
Hi @Tianjiao_Li,
With the default format style I don't have the issue.
So it seems to be in one of the settings in our company style.
I'll attach our company style.
With these settings I have the p...
I've also tried the setting 'Qualify Object Names' set to off, but still the period is being removed. Renaming the alias to multiple characters is indeed a workarouns for this issues, but SQLprompt suggests a single character as alias. / comments
I've also tried the setting 'Qualify Object Names' set to off, but still the period is being removed. Renaming the alias to multiple characters is indeed a workarouns for this issues, but SQLprompt...
I've compared all settings with my college. Everything is the same and still my period is being removed... / comments
I've compared all settings with my college. Everything is the same and still my period is being removed...
It is very strange, as a college of mine has the same as you're experiencing. The period isn't being dropped...
He is still on version 9.0.0.3116
I'm using SSMS SQL Server 2014 see attached image. [image]
I'll compare my settings with his to fin out if I can find the problem... / comments
It is very strange, as a college of mine has the same as you're experiencing. The period isn't being dropped...
He is still on version 9.0.0.3116
I'm using SSMS SQL Server 2014 see attached image.
...
Here is my complete query with returns an error when formatting the query multiple times.
CREATE TABLE dbo.Table1
(
LEGAL_ENTY VARCHAR(2)
)
CREATE TABLE dbo.Table2
(
sourceValue VARCHAR(255)
)
SELECT *
FROM dbo.Table1 AS B
LEFT JOIN dbo.Table2 AS R
ON R.sourceValue = B.LEGAL_ENTY
OR (
R.sourceValue IS NULL
AND B.LEGAL_ENTY IS NULL
)
DROP TABLE dbo.Table1
DROP TABLE dbo.Table2
/ comments
Here is my complete query with returns an error when formatting the query multiple times.
CREATE TABLE dbo.Table1
(
LEGAL_ENTY VARCHAR(2)
)
CREATE TABLE dbo.Table2
(
sourceValue VARCHAR(255)
)
...
I'm using SQLPrompt version 9.0.0.3116
I've just updated to version 9.0.6.3580 but the error still exists. / comments
I'm using SQLPrompt version 9.0.0.3116
I've just updated to version 9.0.6.3580 but the error still exists.