63 results found
-
Extend the column toolstips with the nullable attribute
Extend the column toolstips with the nullable attribute, like this "ic.Attachment varchar(max) not null (Column)"
4 votesThis 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/
-
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.
-
Order suggestion columns name by table schema definition order (not alphabetically)
Add a flag to order suggestion columns name by column order (not alphabetically).
3 votesThe latest version of SQL Prompt 6.3 should show column suggestions by the table schema definition order.
-
Bring back native SSMS intellisense when disabling SQL prompt
When disabling SQL prompt (or when a trial ends) the default SSMS intellisense is not getting back to work.
This is especially important since there are a lot areas that the native SSMS intellisense is much better than SQL prompt (I will try to post all of them), so one might try to take advantage of it.3 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Give us a configurable option to "Always show table schema in suggestions list"
We use a separate schema (z_audit) to capture data changes from dbo tables as a complete audit trail. The tables in each schema are named the same. Every time I come to the suggestions list, I either take it as read that the top table listed is in the dbo schema, or must click that little arrow at bottom-left to "show schema", involving having to grab the mouse just to expose the schema when we're supposed to be efficiently keying; no mousing involved unless we need to use a different suggestions tab...
An option that toggles this to OUR preference…
3 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
select column names
after typing select and adding table name the popup box that shows the table summary (column names and their types); if these rows(column names) be clickable, select columns could be filled from that list instead of typing.
3 votesSQL Prompt contains a “Column Picker” feature that should do what you’re requesting.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
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 -
snippet isn't working correctly
When using snippet with version before 6 (5ish), I could just hit tab and it will give me the correct code. However, with version 6, sometimes (half of the time), the first choice is nothing. It will do nothing rather than giving me the code for that particular snippet. Please fix it. It's very frustrating.
2 votesHi Jay, I think this was fixed a while back but if you’re still encountering any issues with it let us know.
-
Please add a function key to reopen the sqlprompt box.
Here’s what’s happening: I am typing along and I hit space instead of tab which does not complete the fill in (I actually like this so I don’t want to add the space as a completion key). I would like a mappable key combination to get the prompt to re-open.
2 votesCtrl+Space will bring back the suggestion box, but also the latest build of Prompt will bring it back if you just continue typing after you left off (if you didn’t purposely hide it with esc)
-
Enable prompting within a raiserror()
For any attempt to use Intellisense within a RAISERROR() there is no prompting - list says "No suggestions".
Sample:
RAISERROR('Not at 12hrs UTC - time is %s',0,1,@<<Nothing-here>>) WITH NOWAITAlso reported as a defect on the SQL Prompt Forum
2 votesThe latest version of Prompt should give you suggestions within a RAISEERROR
-
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
-
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/
- Don't see your idea?