Posts
Sort by recent activity
Edit Formatting Styles screen vanishes when resultset exists
I've noticed a quirky UI bug when I take the following steps:
1. Run any query
2. Go to SQL Prompt --> Edit Formatting Styles
3. Click 'Edit Style' (incidentally: you really need an "OK" button her...
INTO keyword not aligning correctly
When I start with the following code:;WITH a AS
(
SELECT
1 AS x
,2 AS y
)
SELECT * INTO #tmp FROM a
and apply formatting:
;WITH a AS
(
SELECT
1 AS x
,2 AS y
)
SELECT
a.x
,a.y IN...
FULL OUTER JOIN not wrapping correctly
When I use a FULL OUTER JOIN in my code, it appears not to correctly associated the "FULL" keyword with the rest of the JOIN. The problem doesn't seem to apply to any of the other JOIN types.
Star...
Collapse CASE statements
The "Collapse CASE statements shorter than N characters" option appears to conflict with the Lists --> List items --> "Place first item on new line" option, when the first expression in a SELECT st...
Hundreds of "AWAITING COMMAND" records
This morning I ran sp_who2 on my server, and was alarmed to see 351 SPID values being used by "Red Gate Software - SQL Tools". After some frantic digging, I eventually realized that all of these t...
"Sequence Contains No Elements" when formatting a MERGE
When I try to format any SQL query containing a MERGE statement using SQL Prompt 7.3.0.418, I get a popup error stating that "SQL Prompt was unable to complete this operation. Problem areas have be...
Inline Stored Procedure with OUTPUT parameters
The new "Inline stored procedure" command is quite nice, but it does not seem to be able to handle OUTPUT parameters.
When I use it on a procedure with one normal and three OUTPUT parameters, the n...
Word Wrap settings not respected by BETWEEN
It seems that the "Characters per line" option is still affecting lines that include a BETWEEN statement, even when the "Wrap Text" option is unchecked.
The query below is set up to use some long c...
There is already an object named '#partitions_indexes'
When trying to register a working base on an existing database, I receive the following error: "There is already an object named '#partitions_indexes' in the database."
I have several other databas...
No highlighting in the ORDER BY of a windowed function
When I use a windowed function, such as ROW_NUMBER(), "highlight matching objects" does not pick up on aliases and column names within the ORDER BY section.
For example, in the following code, plac...