Posts
Sort by recent activity
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...
Script as Alter
This is a fantastic feature. It will come in handy for sure.
Here is a suggestion along those lines. On the context menu for a View in the object explorer, it would be totally awesome if you cou...
FORMAT SQL bug - ALTER VIEW statemet
I am a frequent user of the Format SQL statement. It comes in very handy when you're working with others who may use the designer to create views.
When editing a View I like to use format SQL so i...
Candidate lists involving Schemas - Bug and Feature Request
I have two comments on candidate lists involving schemas:
1. This is a BUG: When listing candidates for join conditions, the schema name does not preface the object name and this is faulty SQL.
I...