Activity overview
Latest activity by VernRabe
String concatenation formatting
SSMS 18.1, SQL Prompt 9.5.10. When concatenating strings, it'd be nice to align the "+" signs on a new line. For example, using the attached format file, I get the following, and the indentation in...
Problem solved. Thanks for any effort extended. / comments
Problem solved. Thanks for any effort extended.
How to format WHERE clause
Using SSMS 18.1 and SQL Prompt 9.5.8.10521, I can't seem to figure out how to format a WHERE clause as I'd like. Any help would be appreciated. What I'd like is something like...WHERE A.Col1 = 5AND...
I'm not sure of the status of this, but in 9.5.8.10521 the semicolon after the GO is still inserted if the GO is followed by a comment, e.g., a semicolon will not be added after the GO for the following script. USE [master] GO WITH [test] AS (SELECT [a]=1) SELECT * FROM [test] [t] but it will for the following script USE [master] GO -- WITH [test] AS (SELECT [a]=1) SELECT * FROM [test] [t] / comments
I'm not sure of the status of this, but in 9.5.8.10521 the semicolon after the GO is still inserted if the GO is followed by a comment, e.g., a semicolon will not be added after the GO for the foll...