78 results found
-
display # of objects searched
In the header add the number of objects searched in the database.
1 voteThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Invalid object view - script selected objects as Drop
Would be useful to be able to choose a selection of Invalid objects and generate a Drop script for them all.
4 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Sort Selected Text
Sorts selected lines. Nothing fancy, but incredibly useful.
5 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
highlight the sql bock like while if else etc
if I move the mouse on or click if the next keywork 'then' or 'else' would be highlighted and show the logic sturcture of the block. like what the java or c# ide does. not sure if it is possible or I missed this feature in the product. Thank you.
2 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Encapsulate SQL to View + Suggested index for the resulting view
give the option to encapsulate a piece of code like a subquery into a view so it can be reused , and give an option to create indexes on the resulting views as to max speed to the query
1 voteThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
find unused variables globally
add an option like "find invalid objects" which runs globally on a DB to run "find unused variables" globally
2 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Select DISTINCT Values on column right-cli
So many times during the day, I find myself in executing SELECT DISTINCT on a column, just to find all the unique values in the database. It would be a great shortcut if I could just right click on a column and the SQL statement would be automatically generated.
1 voteThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Format option for short selects to stay on one line
When a SELECT statement is short, for example fits on one line on my screen I would like for the SELECT to not be formatted onto multiple lines. This could even apply to the parts of the SELECT if the entire SELECT statement is long. For example a WHERE statement with only two short clauses could be one line.
13 votesWe’ve released a new formatting engine in SQLPrompt Version 8.
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
-
Format option for no new line after SELECT *
A new Format->Data Statement option for when SELECT * FROM is used that keeps it on the SELECT and FROM on the same line.
2 votesWe’ve released a new formatting engine in SQLPrompt Version 8.
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
-
customizable highlight of query text
The first use case that comes to mind would be to highlight all unindexed fields. This would make optimization an easier task. The type of highlight could be customizable such as a colored squiggle line underneath (like ms word) or an earmark tag. A quick toggle of all highlights on/off would be nice.
To reduce clutter, a simpler option would be to show indexes on hover of the field.
1 voteThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Suggest Alias Even When Table Doesn't Exist
When you have a table in a FROM clause that is aliased, but the table doesn't exist, or is a temp table where the creation isn't in the script or is commented out SQL Prompt doesn't even include the alias as a suggestion. I think it should.
You can see my example in this forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?p=46775#46775
5 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
subqueries - start on new line
I'd like an option under data statements --> Subqueries to be able to drop sub-queries starting on a new line like in section Schema Statements --> New lines.
Example:
SELECT
[pgp].[patientid]
FROM
[dbo].[PTGEPATIENT] AS pgp
WHERE
[PATIENTID] NOT IN (SELECT
patientid
FROM
[dbo].[PTAPALCOHOL] AS paa)would become
SELECT
[pgp].[patientid]
FROM
[dbo].[PTGEPATIENT] AS pgp
WHERE
[PATIENTID] NOT IN (
SELECT
patientid
FROM
[dbo].[PTAPALCOHOL] AS paa
)5 votesWe’ve released a new formatting engine in SQLPrompt Version 8.
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
-
Aliases - auto-assign when none present
The auto-create alias function is a nice feature, but it does not apply to when I want to open an existing script and apply my formatting/refactoring options. Instead the object name becomes the alias name.
For consistency and readability, I'd like to see an option to assign aliases for objects with none even if not typed and using the intellisense features.
4 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
add more flexibility to tabs & wrapping section
At the moment, only 4 options are available in the [Options] -> [Tabs & Wrapping] -> [Characters per line] option. The value can also be changed manually by direct editing of the xml options file but it would be much smarter if you use an editable dropdown box here (so user could pick one of the four values OR key in his/her own value).
4 votesWe’ve released a new formatting engine in SQL Prompt Version 8.
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
-
Table name as alias
I often use fully qualified oject names in code, but then want to alias them just by the table name e.g.
Accounts.dbo.PurchaseOrder as PurchaseOrder
Without having to add all my tables to the custom alias list, I think this represents a useful alternative to simply first letter (or capitalised letters).
Others may have alternative naming schemes, but as long as it can be defined generically enough, I think Prompt should have these built in
4 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
convert sql select statement into linq query
we can see disassembled code converted in various languages using .net reflector. I'm thinking about a tool into right click menu that converts the complex selects into linq statements to copy and paste into visual studio.
4 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Transform the sql select statement into User-Defined Table type
It could be useful to convert a select statement into a user defined table type. Using ado .net i found very important to map collections to my user define table types in sql.
2 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Encapsulate the current statement in table valued function
It could be useful to wrap the result of a select statement into a table valued function (inline or multistatement)
8 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
- Don't see your idea?