63 results found
-
Keyboard shortcut for Snippet Manager
It would be great to have a Keyboard Shortcut to launch the Snippet Manager. I currently have it as a toolbar button, but a shortcut would be good so I don't have to leave the Keyboard..
1 voteThanks for posting your comment about how you set this.
You can also do this using SQL Prompt's Command Palette - Alt+S in SSMS (Alt+P in Visual Studio) and then start typing snippet - https://documentation.red-gate.com/sp/command-palette.
-
When generating Insert code use defaults
If you create a table with a BIT column not nullable with a default value, and then you type insert, the autocomplete gives you null for the bit column. Example below. (I haven't looked at what happens with other data types/defaults.)
CREATE TABLE dbo.MyTable
(
Flag BIT NOT NULL CONSTRAINT DFMyTableFlag DEFAULT (0)
)
GOINSERT INTO dbo.MyTable
(
Flag
)
VALUES
(NULL -- Flag - bit
)1 voteHi,
This feature has actually just been added to SQL Prompt, and will be included in the next release (10.6.11).
Thanks,
Owen
-
transparency
Hi, new feature with transparency on Ctrl in SQL Prompt 9.4.10 is extremely annoying, I'm using only Ctrl+Space to show intellisense. Please provide us option to disable this feature, or change key to Alt or Ctrl+something, this is really horrible, please fix it asap. I've to uninstall tool for now.
4 votesMany thanks for your useful feedback on this issue.
We’ve done some further work on this feature that should hopefully address your issues. This has just been released in SQL Prompt v9.4.11 (available from https://www.red-gate.com/products/sql-development/sql-prompt/).
The popups will now only go transparent after holding the Ctrl key for a short period instead of immediately. This should mitigate the issue somewhat. In addition, there is a new option (in Suggestions → Behavior → Make popups transparent when the Ctrl key is held down) to turn the feature off if it is not wanted.
Kind regards,
The Prompt Team
-
code analysis blocks object detail
SQL Prompt v9.0.2.3223 use of Code Analysis has stopped the tooltip for showing structural details.
ie: statement like SELECT a,b,c FROM dbo.TableRequiringLock WITH (ROWLOCK, XLOCK) WHERE ID = @key
will just show TABLE HINT used when hovering over table name as opposed to showing the structure.
2 votesHi,
I am pleased to inform you that your request has been taken into account. Please update to the latest version in order to use it!
Regards,
Fabiola -
Code Analysis config to flat file
Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.
Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway…
7 votesHello,
We added this feature recently (in SQL Prompt 9.1.0.4138).
Now it is possible to save your settings file in a shared folder for the team to use or switch between different settings files. This is accessible via the Prompt menu : SQL Prompt > Manage Code Analysis Rules….
Let me know if you find it helpful.
Kind regards,
Alicja -
DBCC SHOW_STATISTICS('...','...) WITH DENSITY_VECTOR
Hi!
It would be nice to have an IntelliSense for the DBCC SHOW_STATISTICS command.
When typing
DBCC SHOWSTATISTICS('HashAggregation','WASys00000001_2A8B4280')
it would be helpfull to get the option of "WITH DENSITY_VECTOR" for example.
1 voteThis feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Change Filename add NEWNAME
ALTER DATABASE <DB Name>
MODIFY FILE (NAME = '', NEWNAME = '')1 voteHi Lee,
Thanks for letting us know about this. NEWNAME is now suggested in SQL Prompt 7.2 which you can download from our website or through Check for Updates in the SQL Prompt menu.
-
Give the option to disable Microsoft Help suggestions.
I have never clicked on a suggestion that results in opening the Microsoft Help window on purpose.
As an example, if I have a long "IsNull" that takes up multiple lines, a tip box will pop up blocking portions of the query, and no matter where I click, this will pop up and block different portions. Often I will accidentally click the box as I need the cursor to be where the box is, and it will cause the dev environment to become unresponsive while the "Help" window loads.
1 voteHi Danny,
It’s already possible to disable these tooltips in SQL Prompt. If you open up the SQL Prompt options, on the first page it’s under “Show tooltips for: Parameters”.
Thanks,
Aaron. -
Better SQLXML Support....
SQL XML is a great tool that gets very little support. When I am on an XML type variable...the intellisense isn't great....AT ALL. Doing something like:
declare @xml XML;
set @xml = '<Tests><Test><Id>1</Id></Test></Tests>';select @xml.value --This doesn't have intellisense. It will try to capitalize .value to .VALUE which isn't correct.
So better SQL XML support would be nice.
1 voteHi Mario,
In your example “value” will be suggested and left as lowercase in the latest version of Prompt 6. If you’re still having problems even on the latest version please contact support as you may have hit a bug.
Thanks,
Aaron. -
Add support for SQL CMD variables in SSDT/VisualStudio
When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.
SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
Then a becomes an "unresolved alias"1 voteThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
"d" in "order by" should prompt with "desc", not "dbcc"
Currently if you type a query like this:
select *
from sys.objects o
order by o.name d[CURSOR]the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.
While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.
1 voteThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Dot insertion key breaks IP addresses in Linked Servers
I added the 'dot' option to insertion keys and now I am unable to type dots in an IP address for a linked server without it autocompleting some random address, which I then have to go back and correct.
1 voteThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add ParserLookBackDistance and ParserLookAheadDistance values to the Options menu
Due to the length of some of the queries I write, I have to edit the file RedGateSqlPromptEngine_EngineOptions.xml manually. It would be nice to be able to edit the values for ParserLookBackDistance and ParserLookAheadDistance in the Options menu. I understand the drawbacks of making these values too large. If they were in the Options menu I could adjust them for a long query and then set them back for shorter queries.
3 votesThese options have been superseded with a new system in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
When coding ALTER TABLE xxx DISABLE TRIGGER, list just that table's triggers, not every one on every table
The suggestions list after the TRIGGER is full of triggers. SQL Prompt, having been given the schema and table should narrow that list to only those present on the table to be ALTERed.
I would categorize this as a bug, rather than a suggestion...
5 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Allow me to specify schemas to include or exclude
The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.
34 votesWe added schema filtering in SQLPrompt 9.4.15. You can learn more about the feature here: https://documentation.red-gate.com/sp9/managing-sql-prompt-behavior/managing-connections-and-memory
We would love to hear your feedback.
-
Search Middle of Snippet name
Intellisense should find snippets where characters appear anywhere in the snippet name, not just at the beginning. I have 2 or 3 dozen snippets and I can't always remember what the less frequently used snippets are called. For example I might several snippets that deal with space usage, but some are named like this: "getSpaceUsage". It would be useful if typing "space" found all snippets that contained space anywhere in the name not just at the beginning.
4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
2014 ctp2 support
please add support for sql 2014 ctp2, i'm already using it and im sure others are as well and quite frankly i've grown very accustomed to using sql prompt that it became quite hard to work without it.
i hope you can add the support really soon
9 votes -
SQL Prompt tries to retrieve objects from other databases
After upgrading to SQL Prompt 6 (6.1), I notice reduced performance and I occasionally get "SQL Prompt cannot retrieve objects from <some database name>. (etc)", which reference a database that I do not use or am ever likely to use and IIRC have never used. It seems SQL Prompt is trying to cache objects for all databases on the connected server. That would be overkill, and only serves to slow it down and cause errors such as the one mentioned.
3 votesThis was likely due to the synonym support added in 6 which will try to offer suggestions by loading databases that the synonyms are referencing. In the latest build of Prompt this is optional (under Suggestions→Connections) and off by default.
-
Delay before Suggestion dropdown [Bring it back]
I used to have a couple hundred milliseconds of delay in here. This was really helpful in some circumstances to allow me to do down a line of text adding tabs, spaces, commas, etc. (all kinds of things to satisfy my obsessive need for proper formatting). Without this option I now have to hit [ESC] each time to clear the suggestion box no matter how quick I move down, making this an annoyance.
6 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Grant no longer suggests Domain users or groups
When typing a GRANT statement I no longer suggestions after the "TO" for domain users or groups that exist in the database. I only get SQL Users.
Please include all users in "Security\Users" after the "TO" in the GRANT statement intellisense.
4 votesThis is fixed in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
- Don't see your idea?