Posts
Sort by recent activity
Temp tables and Suggestions Not Showing
I am running SQL Prompt 4.0.4.14 and have found that in some cases suggestions aren't showing up for temp tables.
Given this code:
SELECT
Backup_set_id,
MIN(first_family_number) AS F1
IN...
Turn SQL Prompt off for one window in SSMS
I would like to request a couple new features in SQL Prompt:
* An option on the "SQL Prompt 4" menu to disable/enable SQL Prompt. (I was sure that it used to be there, but maybe that was in 3.x, no...
Once connection to linked server fails, SQL Prompt gives up
I ran into a problem today when the first time I tried to create a query against a linked server and the server was down SQL Prompt gave me an error. Later once the server was back up I can't find ...
ALTER TABLE incorrect tool-tip
With this code:
ALTER TABLE msdb.dbo.backupfile ALTER COLUMN media_set_id<cursor> VARCHAR(10);
If you hit ctrl-space it shows information about the media_set_id field in the BackupM...
Format SQL and ALTER TABLE
I am using SQL Prompt 4.0.4.14 and have found that the Format SQL doesn't like the ALTER TABLE queries much:ALTER TABLE msdb.dbo.backupfile
ADD Test VARCHAR(10) NULL;
Becomes:ALTER TABL...
Format SQL Fails with FOR XML query
SQL Prompt 4.0.4.14 fails with an error saying:
"SQL Prompt was unable to format this script because some syntax errors were found while it was being parsed. These errors have been highlighted."
wi...
Format SQL Fails with CURSOR declaration
Using SQL Prompt 4.0.4.11 when I format this code:
DECLARE crsScheduledTickets CURSOR FOR
SELECT
backup_set_id,first_family_number,first_media_number,filegroup_name,page_size,file_number,backed_...
No Suggestions When FOR_XML used in Sub-Query
Another problem with no suggestions with certain code:SELECT
EI.SampleField,
(SELECT EI_2.Part + ','
FROM (SELECT 1 AS SampleField, 'Part 1' AS Part
UNION ALL
SELECT 1 AS ...
Missing Suggestions in Sub-Queries in SELECT portion
SQL Prompt 4.0.4.11 doesn't list the proper suggestions in sub-queries in the SELECT portion of a query:SELECT
*,
(SELECT COUNT(*) FROM msdb.dbo.backupfile C WHERE C.backup_set_id = ...
ORDER BY suggestions do not include SELECT aliases
SQL Prompt 4.0.4.11 doesn't suggest aliases defined in the SELECT portion of a query in the ORDER BY portion.SELECT
'Test' AS Field1
ORDER BY
<cursor>
With the above query "Field1" should...