Posts
Sort by recent activity
SQL Search - Database Selection Reverting to All Databases
I've noticed that when I flip over to another app and flip back to SSMS that the database selector changes from the one DB I have selected to All Databases. Ans so my search results are skewed of ...
SQL Search Greyed Out No controls usanble
For some reason SQL Search is completely disabled. Tried restarting SSMS, Uninstalled Search and reinstalled,. Opened a SQL Query before opening Search. Highlighted a DB before opening Search, ...
Change syntax of Auto-generated Insert Statement
Is there a way in SQL Prompt to change the syntax of the auto-generated INSERT statement to use a SELECT instead of a Values clause?
Indexing hangs on large database
I am using SQL Search on an Infor SyteLine database. There are hundreds, if not thousands of objects in the database. SQL Search freezes when I try to search for something. It freezes on Indexin...
Cast as Block Snippet bug - bad comma
The Cast As Block snippet should not have a comma in it.
CAST($SELECTEDTEXT$, AS $CURSOR$)
Corrected:CAST($SELECTEDTEXT$ AS $CURSOR$)
Table varaible suggestion enclosed in square brackets
I am declaring a table variable and then when I use the table variable, the suggestion is enclosing it in square brackets erroneously. When a variable is enclosed in brackets, then SQL thinks I am...
Missing Schema in Join Condition Suggestion
An old bug seems to have reared it's ugly head. I am using version 7.1.0.315 on SQL 2012SELECT * FROM Billing.Invoices
INNER JOIN dbo.jobJobs ON jobJobs.iJobID = MISSINGSCHEMA.Invoices.iJobId
...
Refresh Suggestions not working properly
I upgraded to the latest version of SQL Prompt recently. If I alter a table or add a new proc or function and then do Refresh Suggestions, the new objects are not showing up in the suggestion list....
Issue with SELECT and the word FROM in DB Objects
In settings, I have "List all database columns after a SELECT statemet" unchecked.
So in order to get column suggestions, what I willl normally do is type SELECT<enter/newline> and then type FROM <...
Minor issue with SCF snippet
Hello. In the SSF snippet, it has a trailing space so all you have to do is type in the table name.
In the SCF snippet there is no trailing space so you have to hit space yourself.
I edited the SC...