Posts
Sort by recent activity
Can I ignore "NOT FOR REPLICATION" ?
Can I ignore "NOT FOR REPLICATION" on Identity columns?
Easy way to enable Sql Prompt after Mgt Studio Reinstall?
Besides reinstalling SqlPrompt. I see the menu options, but they don't work.
Automatically adding JOIN statements
I do not think Sql Prompt should include the ability to add JOINs to your SQL as you are typing. (Or add the table names while adding fields to the SELECT clause).
I base this off of non-stop use o...
CTRL + ARROW
I frequently use CTRL+LEFT/RIGHT arrows to move around. If Sql Prompt kicks off the candidate list, I am no longer navigating the cursor but switching the items in the Candidate list.
Perhaps SHIFT...
Exception: ' ' is an invalid name.
I got this after I deleted a line from my query and then pressed the up arrow several times.
The line I deleted is the line that starts with "LEFT OUTER JOIN CCH.dbo.APP_COL" in the first half of t...
Bug with Formatting Sql containing Comments
I have a .sql text file that contains a simple SQL statement where I have commented out a portion of the where clause.
I open the .sql file in Mgt Studio and choose "Lay Out Sql". I then get the er...
REFACTOR BUG WARNING!
Caps and an exclamation -- so you know this must be important. :-)
There is a bug with the current version of Refactor where lines do not get a CR/LF at the end.
Consider the following statement an...
Exceptions
Below are some of the exceptions that I get when I open Sql Mgt Studio, or sometimes while editing a .sql file. While editing a file it appears to be when I am deleting text -- possible only when I...
Reported Bugs Sticky?
I have come across several unhandled exceptions and a few other bugs/oddities.
It would be nice if there was a post of 'reported bugs' so I know how detailed of a bug report to make. If it's alread...
Candidate List in FROM clause
In the WHERE clause, the candidate list displays fields from tables that are not in the FROM clause.
I do not like how it shows these fields as options or how it adds the table to the FROM clause w...