Activity overview
Latest activity by orderbynewid
I have the database compatibility level set to 160, so the syntax with leading/trailing/both is correct, but the formatting is incorrect. / comments
I have the database compatibility level set to 160, so the syntax with leading/trailing/both is correct, but the formatting is incorrect.
I can confirm that this has been fixed in SQL Prompt version 10.14.6.5992. / comments
I can confirm that this has been fixed in SQL Prompt version 10.14.6.5992.
Thank you; that works in this specific case. I was not aware of that option and would have thought that "Add a space after parentheses" would be the default behavior. The result, when using the defaults, looks non-standard to me. / comments
Thank you; that works in this specific case. I was not aware of that option and would have thought that "Add a space after parentheses" would be the default behavior. The result, when using the def...
Missing indentation after WHILE
SQL Prompt version: 10.14.4.4865
SQL Server Management Studio version: 19.2.56.2
SQL Server Version:
Microsoft SQL Azure (RTM) - 12.0.2000.8
Microsoft SQL Server 2022 ...
Missing spaces after parentheses
SQL Prompt version: 10.14.4.4865
SQL Server Management Studio version: 19.2.56.2
SQL Server Version:
Microsoft SQL Azure (RTM) - 12.0.2000.8
Microsoft SQL Server 2022 ...
TRIM with LEADING/TRAILING/BOTH breaks formatting on Azure SQL Database
SQL Prompt version: 10.14.4.4865
SQL Server Management Studio version: 19.2.56.2
Database Compatibility Level: 160
Active Style: Default
Before formatting
sElEcT tRiM(lEaDiNg '0' fRoM ...