Posts
Sort by recent activity
GO capitalization issues
GO never seems to capitalize. If I type "g" and hit ENTER or TAB it capitalizes...but not if I type the word "go" and then hit ENTER. This is odd because it works with other keywords.
v4 formats this differently than v3
I recently upgraded to v4.0.3 from v3.9 and when SQL Prompt auto generates my insert statement it now does this...INSERT dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VAL...
DB Pro 2005: System.ArgumentException: Unable to create AST
I am trying to do a Schema Compare between my project and the dev database and VS 2005 crashes when it gets to the part "Comparing Databases". I can compare the test database to the dev database, ...
Doesn't capitalize keyword where
When I type a query such as this...
SELECT *
FROM sys.databases
where [name] = 'temp'
I will capitalize SELECT and FROM when I hit tab, but not WHERE. It also capitalizes GROUP B...
Feature Request: Customizable key words
I like the feature that capitalizes key words like SELECT or CREATE, but there are a lot of words that it doesn't auto complete or capitalize. I would like the ability to add my own words to a dic...
VS Error in Unit Tests
I get this error when I try to write a database unit test.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text...
What happened...
What happened to the old forum?
Candidate list suggestions
It would be nice if the candidate list only showed unique entries. I have a field name AccountID in 7 table in my database and when the candidate list pops up I see all 7. Selecting 1 as opposed ...
Join Table Name Qualification
It would be nice if Sql Prompt had an option to not qualify the table names with the owners/schemas on joins.
Something like this...
Select Table1.Column1
From dbo.Table1
Inner Join dbo.Table2 On T...
Command the Suggestions
It would be nice if Sql Prompt wouldn't pop up the candidate list or make any changes to what I type in a comment block. I have the option to capitalize keywords and if I type in "Made a small cha...