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...
Mark, et al:
SQLSaturday Oregon is typically the weekend before the Summit (and only a SQL Train ride away) and we get great speakers and typically over 400 attendees. We'd love to have Redgate there.
Vern Rabe / comments
Mark, et al:
SQLSaturday Oregon is typically the weekend before the Summit (and only a SQL Train ride away) and we get great speakers and typically over 400 attendees. We'd love to have Redgate the...
Looking forward to it. BTW, the Eventbrite site lists October 24 in the Description, but October 30 in the actual event date. / comments
Looking forward to it. BTW, the Eventbrite site lists October 24 in the Description, but October 30 in the actual event date.