Posts
Sort by recent activity
Format list items with indent for subsequent items
Prompt is no longer indenting subsequent list items when using tab only. For example, setting Whitespace tab behavior to Only Tabs and formatting the following code using any combination of 'Align...
Format SQL Fails After 'AT TIME ZONE' Clause
SQL Prompt 8.0.7.1917
SQL Server 2016 SP1 13.0.4422.0
On the following SQL, Format SQL fails to format with error "Error Inserting Semicolons". The result after this error is the column alias 'sca...
Autocomplete stored procedure parameter date values shown as datetime
When autocomplete fills out the parameters for a stored procedure with a date parameter, a datetime value is incorrectly entered instead of a date value:
EXEC rpt.usp_get_list@vXCode = '' -- ...
Bug: Format SQL fails for "at time zone" (v8.0.5.1758)
When formatting a select statement with the following column:
CONVERT(Time, lpr.scandatetimeutc AT TIME ZONE 'UTC' AT TIME ZONE dlr.tz_name) AS time_local
SQL Prompt adds 'AS' into the column like ...
SQL Prompt Suggestions do not appear in Row_Number clause
When writing a row_number() clause, sometimes there are no column suggestions or automatic alias prefixing for the partition or order phrases:
row_number() over (partition by col1, col2, col3 order...