Posts
Sort by recent activity
Bug - No Column Candidates in Subquery
This is a reproducible problem for me:
SELECT (
SELECT TOP 1 Col1
FROM Table2 AS t2
WHERE t2.
) as val
FROM Table1 AS t1
In the query above, typing the '.' after WHERE t2 does not get any response...
Suggestion - Table/View Candidate Columns
When you type 'SELECT * FROM '...
...Sql Prompt displays a list of tables and/or views in the candidate list, and when you highlight one of those tables or views, it shows the definition in another...
INFORMATION_SCHEMA - Beyond Glitch!
So I installed SSMS 2005 and upgraded to Sql Prompt 3.7 as per your suggestions. Now the INFORMATION_SCHEMA views do not appear no matter what I try.
This thread has the original problem I encount...
Brackets Always Inserted For Temp Tables
Sql Prompt 3.6. SQL 2000. Query Analyzer.
SELECT * FROM #TempTable
causes Sql Prompt to always reformat as...
SELECT * FROM [#TempTable]
...even when "Surround identifiers with brackets" is not c...
HUGE Delay on Undo
QA hangs for like 3-5 sec. My PC is a Core2 Duo @ > 2GHz.
Totally maddening.
Why necessary?
Bug - Variables Missing From Candidate List in Stored Proc
I'm using Sql Prompt 3.6 in Query Analyzer with SQL 2000.
I have observed the following reproducible bug. Below is a sample stored procedure that will exhibit the problem.
CREATE PROC sptest @a nv...
Sql Prompt Exception
While working with Sql Prompt 3.6 in Query Analyzer today, I randomly got the folllowing exception:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this ...
INFORMATION_SCHEMA Glitch
I just downloaded the 3.6 eval and encountered the following problem. I am using SQL 2000 with Query Analyzer, and I enabled the "System Objects" candidate types in the Sql Prompt options.
After t...
Typing while inside single quotes
Tell me if there's something I'm missing here, but shouldn't SQL Prompt ignore input while the cursor is in between single-quote chars (because that means you're entering a literal string and not a...
Supposed to recognize views and user-defined funcs?
Hi, I'm trying out SQL Prompt 3, and it seems improved over SP2 (especially the UI), but I have some questions:
1 - Is it supposed to know about views? I get no suggestions for views or columns in...