Posts
Sort by recent activity
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...
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...
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...
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...