Activity overview
Latest activity by alicorn68
BUG: Semi-Colon after GO followed by WITH
Test code:USE [master]
GO
WITH [test] AS (SELECT [a]=1) SELECT * FROM [test] [t]
After using menu "SQL Prompt->Insert Semicolons" that becomes:
USE [master];
GO; -- ISSUE IS HERE
WITH [test] AS (SE...
Just updated to 9.0.10.4053. This is still reproducible. / comments
Just updated to 9.0.10.4053. This is still reproducible.
Would someone from RedGate please attempt to reproduce this issue?
If it helps I have attached one of the styles tested. All styles seem to have the same issue.
Note: This issue is not shown (does not occur) when editing the style and using "Preview current query" / comments
Would someone from RedGate please attempt to reproduce this issue?
If it helps I have attached one of the styles tested. All styles seem to have the same issue.
Note: This issue is not shown (does ...
Bug - Semicolons added to GO if GO followed by CTE (WITH)
SQL Prompt: 9.0.9.3951 (latest as of this writing)
Simplest reproducible I was able to come up with (entirety of the script):
SELECT a=1;
GO
WITH base AS (SELECT b=1) SELECT * FROM base o;
-- Resul...
As usual, Red Gate is reading my mind. Fixed by v.6.5.0.335.
Thanks for the great help! / comments
As usual, Red Gate is reading my mind. Fixed by v.6.5.0.335.
Thanks for the great help!
BUG: Columns not shown in dialog after a CHECK constraint
I am using SQL Prompt v.6.5.0.323
The expected list of columns in the SQL Prompt dialog does not show when a CHECK constraint is used in a temporary table variable.
Not a show-stopper, by any means...
Latest version fixed the issue.
Thanks for the help, and the great product. Really looking forward to see the SQL formatting improvements that are coming down the pike. / comments
Latest version fixed the issue.
Thanks for the help, and the great product. Really looking forward to see the SQL formatting improvements that are coming down the pike.
I'm on 6.4.0.506. So, I'm way back. I'll install the latest version and update the thread.
Thanks! / comments
I'm on 6.4.0.506. So, I'm way back. I'll install the latest version and update the thread.
Thanks!
Unable to show database objects
When attempting to load the database objects for a specific database [Customer] SQL Prompt throws an error: "SQL Prompt - Unable to show database objects"
Details are: "SQL Prompt could not retriev...