279 results found
-
Ability to set "Show schemas" as the default option for the candidate list
When object names appear in the candidate window for an autocomplete, the schemas are not shown by default. Clicking on the the arrow in the bottom left of the window will show them, but this setting is not remembered so you have to do it each time. Also there's no keyboard shortcut that I can find to do this. Add the ability to set this popup to show the schema names by default.
7 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Please provide intellisense even when not in the current database
In SSMS when accessing a table that is not in the current database (using the three part convention) then no intellisense is coming up for the fields (such as in the where clause)
1 voteSQL Prompt now supports suggestions from other databases when using the three part convention.
Kind Regards,
The Prompt Team
-
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/
-
format join
I would like the ability to get Format SQL to handle my JOIN formatting - I like to have my JOINs look like this:
SELECT
(columns)
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECTID = i.objectidThat is: I want to have my tables being joined lined up with the (intended) table in the FROM clause, and I like to have my JOIN condition on the same line as the joined table.
Right now, I cannot seem to get this to work - the table name and join condition are always stuck onto the same line as…
7 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Script Object as ALTER feature should not use cached scripts
Please see forum thread http://www.red-gate.com/MessageBoard/viewtopic.php?t=14749
I ran into what I would consider a serious issue with the Script Object as ALTER feature. A few hours earlier I had changed a stored procedure script and executed the Alter script so the change was now "active".
A few hours later, within the same SSMS application (but different query window) I used the right-click Script Object option as a shortcut so I didn't have to scroll through a very long list in Object Explorer... Unfortunately it scripted the OLD version of the procedure and not the one changed hours earlier.
Now, I know…
2 votesAs of SQL Prompt 5.2.8, Script as ALTER will always fetch the script directly from the database.
-
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/
-
Enhance the Format SQL to recognize the WITH clause.
When the WITH clause is specified in the FROM clause on a JOIN, Format SQL pushes the join condition out to the WITH.
Like this:
FROM
TableA WITH (NOLOCK)
JOIN TableB WITH (NOLOCK)
ON TableA.ID = TableB.IDI would like it to behave like it does when the WITH is not present
FROM
TableA WITH (NOLOCK)
JOIN TableB WITH (NOLOCK)
ON TableA.ID = TableB.ID7 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Supprt Quoted identifiers for prompting
If you go
SELECT * FROM sys.tables AS t
or
SELECT * FROM sys.tables AS [t]then intellisense will happily carry on working correcly, with t. now showing object members.
However
SELECT * FROM sys.tables AS "t"
and
SELECT * FROM sys.tables AS 't'both cause the intellisense to give up for the rest of the batch. All four identifier markups are valid (for now) and should be treated equally...
1 voteSQL Prompt 6.3 resolves quoted identifiers correctly
-
improve performance in SSMS when CTE statements are in the script
Or maybe an option to disable parsing of statements using CTEs. My keyboard takes seconds to respond when several CTEs are in the script.
5 votesWe’ve just released SQL Prompt 6.1 which shouldn’t slow down typing when CTEs are used
-
Turn Off Schema Collection
I'd like to enable schema collection when I'm writing code, and disable it when I'm doing adhoc queries. Why: We have 100 identical databases with 1900 tables in each database. When I run a query that pulls data from each database sqlprompt starts collecting schema data from all 100 databases, then it runs out of memory and crashes.
The "Turn Off Prompting" option does not help.example:
select id,customer from DB1.dbo.orders where date > @d
union select id,customer from DB2.dbo.orders where date > @d
...etc...4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
"commarise"
When copying a list of items from something like Excel, it would be lovely to have a feature in Prompt which would highlight the list, hit a key stroke and it would place quotes around each item and a comma after them.
It would stop me bashing the quote + arrow + comma keys at the speed of light.
22 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
SELECT DISTINCT starts new line and loses indentation; keep SELECT DISTINCT on same line please.
I believe the DISTINCT keyword should remain on SELECT line but at least maintain the indentation please. Thanks
6 votesWe’ve released support for this piece of formatting in version 8 of SQL Prompt.
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
-
unformat
It would be nice to select a small already formatted script, and unformat it by putting it into one line.
5 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Make ctrl+C copy to clipboard work from code popups
When viewing code in a pop-up having hovered over an object e.g. a stored proc, you can only copy by clicking the Copy button (top right). I would like to be able to use ctrl+c
40 votesWe’ve released SQL Prompt 6 which includes this.
-
Merge command formatting options
Please add formatting options for the deferent parts of the MERGE command like you have for INSERT
8 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Indent comments consistent with code
I'm finding my comments are hanging out all on their own after the rest of my code is formatted. I would request a feature to allow comments to indent to the same level as the code on the line below.
56 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Support for SQL CMD Mode
Please add support for SQL CMD mode. When SSMS is in SQL CMD mode, SQL Prompt pretty much becomes disabled when :setvar is used to define an object (e.g. table) name. Thus, in the code:
:setvar mytable "dbo.mytable"
select * from $(mytable)SQL Prompt is of no use. SQL Prompt should be able to resolve $(mytable) to the base object.
17 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Option to sort column lists by table order as rather than alphabetically
Have an option to sort the column list as it appears in the table rather than alphabetically. I have a good memory for where the functionality sits in the table, but I don't always remember the name. Columns are often logically placed in the table.
3 votesSQL Prompt 6.3 will display the columns in their table order rather than alphabetically
-
Add options for CASE WHEN ELSE END
I'd like to be able to configure a style for CASE statements using options like the following:
- New line after THEN
- New line before ELSE
- New line after ELSE
- ELSE match indent of CASE
- END match indent of CASE
It would also be nice to have a threshold setting (in number of characters) so the formatting settings are only applied if the length of a CASE statement exceeds the threshold.
64 votesThis feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
-
Invert Aliasing
As you select a Table say LotBaseLog , we get auto aliasing to give
Select * from LotBaseLog as lbl
What about using the alis in reverse
Select * from lbl
Gives
Select * from LotBaseLog
Have a look at Resharper Camel Hump principal
Maybe an even better shorthand
Mike
2 votes
- Don't see your idea?