Posts
Sort by recent activity
Cache not generated.
If in Query Analyzer I clear the cache using the "Clear Cache" button the cache is not re-generated for the current session. I had to select the database from the drop down list for the cache to be...
Cannot select from Candidate List on Using INNER JOIN
I am using Query analyzer. The database I am using is Northwind.
You can try replicate it using the following SQL.
SELECT * FROM [Employees] INNER JOIN
I am trying to do a self join here....
Multiple FROM Clause inserted
Start with the following SQL:-
SELECT
FROM [Categories]
FROM [Categories]
Now if you add fields you get a new FROM clause for every field. I added 2 fields and got 2 more from cl...
SQL Prompt freezes Query Analyzer and SSMS
On typing certain words or pasting(Ctrl+V) those words in query analyzer while SQL Prompt is active freezes query analyzer. You have to crash out and restart query analyzer to continue working.
Candidate List and Schema Information Panel size settings
I can resize the Candidate List and Schema Information Panel.
The size settings are saved for the current Query analyzer session.
But when I open another session of query analyzer I get the default...
Candidate list Bug
In query analyzer when the candidate list drop down is open if you resize/move/maximize the query analyzer window the drop down remains open in the same position. It would be better to close the d...
SQL Prompt stops working
In query analyzer if you disconnect all connections and then connect again without closing query analyzer SQL Prompt stops working for that instance of Query Analyzer.
The candidate list does not open automatically
The installation of SQL Prompt 3 went on fine.
After the installation I opened up Query analyzer.
The candidate list does not open automatically as I type SELECT and then press SPACEBAR.
I had to ...