Posts
Sort by recent activity
Tables not showing up sometimes
I have noticed that sometimes when I create a new query it appears that that window uses an old version of the cache information.
For example while in query window 1 a new table is added, and I ref...
SQL Prompt not forgetting outdated learned information
In SQL Prompt 3.8.0.244 if it learns about a table via code, for example:
SELECT *
INTO New_Table
FROM Orig_Table
At that point SQL Prompt adds New_Table to it's cache, and can give you candidates ...
Code inserted by SQL Prompt 3.8 not marked as new
When SQL Prompt 3.8.0.244 inserts code like when building a INSERT INTO query the code it puts in doesn't get the lines flagged as changed (yellow) by SMSS.
Not a big deal, but it would be nice to ...
Slowness opening files in 3.8
I have noticed since I upgrade from SQL Prompt 3.7 to 3.8 that opening a .SQL file in SMSS takes considerably longer. I don't remember any delay with 3.7, but now with 3.8 it usually takes 5 or mor...
Error with 3.8.0.244
Given this:
IF object_id('tempdb..<cursor>') IS NOT NULL DROP TABLE #Temp
and you try to type #Temp you get this error (or even just try to cursor or select inside the string):
See the end of this ...
SQL Prompt and "Open Table" window
Is there any chance of getting SQL Prompt to work in the "Open Table" window?
In SSMS if you right click on a table and choose "Open Table", and once the window opens you click the "Show SQL Pane" ...
Formatting bug when expanding * related to temp table
Given this code:
SELECT
'' AS [Federal Tax ID]
INTO #Test
SELECT *<cursor> FROM #test
If you hit TAB to expand the * to list all the fields it makes the select statement look like this:
SELECT Fede...
SQL Prompt not totally ignoring commented code
Given this example:
RAISERROR ('The E_R_U has <cursor1> completed successfully today.', 18, 1) WITH SetError;
<cursor2>
/*
DECLARE@Id int,@dBegin datetime,@Run_dt datetime,@Update_dt datetime;
BEGI...
Table names not suggested
Given this code:
DECLARE@tStart_Date DATETIME,@tEnd_Date DATETIME
SET @tStart_Date='11/17/05';
SET @tEnd_Date='12/31/05';
TRUNCATE TABLE <cursor>
there are no table names in the suggestions that po...
No suggestion prompt
I get no automatic suggestion prompt if I type the following:
SELECT *
FROM MASTER.dbo.spt_values msp
WHERE 1<>msp.<cursor>
But if I hit ctrl-space it does bring up the suggestions, just not the co...