276 results found
-
Change formatting of IF statements.
When an IF is short and does not have a BEGIN END on it, have it format to a single line.
Right now if you have
IF @Parameter1 = 0
RETURN -1
IF @Parameter2 = 0
RETURN -2I would like it to be:
IF @Parameter1 = 0 RETURN -1
IF @Parameter2 = 0 RETURN -2which would make it more compact.
23 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 -
highlight similar words
Double clicking a word hightlights all instances of that word. This makes it easier to see where the word is used. Good for particularly long scripts.
Double clicking a table, column, function, view etc. highlights all in your script.64 votesWe’ve added the “Highlight matching objects” experimental feature in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Recognize double quotes for object names in the same way as square brackets.
Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.
For example, typing:
SELECT * FROM [MyTable]
will allow the expansion of the asterisk, while
SELECT * FROM "MyTable"
does not.SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".
1 voteThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
6 votes
We’ve just released SQL Prompt 6.1 which shouldn’t slow down SSMS with huge scripts.
-
Eliminate or reduce the need to continuously “Connect to Server…” within Visual Studio 2012
I find it extremely frustrating that each time I want to run SQL Prompt against a new query window (within Visual Studio 2012) I’m forced to “Connect to Server…” Is there no way to inherit the current connection made when opening a new query window or an existing stored procedure?
I’ve been an avid user within SSMS and would like to make the transition to working within SSDT projects. This is definitely a deterrent to using SQL Prompt within Visual Studio.
45 votesWe’ve released SQL Prompt 6 which includes a fix for this.
-
Do not indent FROM and WHERE clauses
Provide an option to not indent the FROM and WHERE clauses to remain them lined up with the SELECT clause while maintaining a single space after each clause.
9 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!
-
2012 keywords
2012 keywords like LEAD( LAG( etc.
9 votesWe’ve released SQL Prompt 6 which includes support for 2012 analytic functions (LEAD, LAG, CUME_DIST, etc)
-
4 votes
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Make intellisense recognize procedure/function valriables
Intellisense does not seem to recognize variables declared within the current stored proc. This would be helpful.
9 votesThis was fixed a while back – I’m sorry for not updating your request sooner!
You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
When using default values for INSERT can you display GETDATE() instead of getting the current date and displaying that?
When using default values for INSERT can you display GETDATE() instead of getting the current date and displaying that?
9 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Intellisense for User Defined Table Types
When using a variable of a user defined table type, make intellisense smart enough to recognize the data type and provide the columns similar to if it were an actual table.
10 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add constraints to column details on column hover
Small suggestion, but I would find this useful!
When hovering over a column you get a balloon that states:
[Table Name].[Column Name] [Data Type] (column)
If this could include 'NULL' or 'NOT NULL' this would be super :-)
Possibily even more, such as default values or identity status?[Table Name].[Column Name] [Data Type] [NULL/NOT NULL] (column)
SQL Prompt is an excellent bit of kit, top work guys!
10 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Support Tab Magic in SSMS 2012 ASAP
The VS-based "tool" is significantly less usable than SS2008R2. Tab Magic will significantly ease the pain of having to work with tabs in the limited manner SSMS2012 inflicts upon us, especially those of us livid over the loss of the MDI-mode!
91 votes -
Query Tab Coloring based on instance and database
As for now, it appears that query tab coloring only is based on instance. In smaller environments, it is not uncommon to see for instance both production, test and stage in the same instance. As for now, Query Tab Coloring does not work very well in such scenarios.
18 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Ability to quickly switch SQL formatting styles.
We need the ability to quickly switch between T-SQL Formatting styles.
I work on a team where everyone likes code formatted differently. Also, we're required to use a specific format before checking SQL Code into TFS. I need a quick way to switch between styles so I can code in a format I like and then switch to our standard before check-in. Toad already offers this.
8 votesVersion 8.0 of SQL Prompt allows you to quickly switch between formatting styles by clicking SQL Prompt → Active Style → (the style you’d like).
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
-
smart rename local
We would like to (smart) rename local variables in stored procedures.
2 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
auto suggest when character is added after table is selected so when SalesOrderLine is shows after SalesOrder
Intellisense should pop up when a character is added after table is selected so when there is a table named SalesOrderLine it should be suggested even after the table SalesOrder was chosen via tab if i type further without a space.
1 voteThe latest version of SQL Prompt (6.3) should show the suggestions again once you type the “L” after SalesOrder
-
Ability to "automatically" remove comments from a section of code.
I really like how SQLPrompt assists with Insert Statements. However, I am then left with a large list of comments which I'm not allowed to check into source control. Therefore, I have to manually delete each line of comments.
Example:
Insert into Blah blah..VALUES ('', -- fenumber - char(3)
'', -- finumber - char(3)
'', -- fpartno - char(25) )When I enter the values, I want to be able to auto-eliminate the comments.
7 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Installation
When installing, allow user to select which instances of SQL Server Management Studio and Visual Studio to integrate with. A simple list of supported products with check boxes next to each. For example, I may not want to integrate with Visual Studio, but just with SSMS. Or not with SSMS 2010, but only with SSMS 2012. And so on.
The current behavior is to integrate with every installed product that is supported. This may not be what the user wants (in my case, I do not want the integration in Visual Studio). I know that I can disable SQL Prompt…
6 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
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.
- Don't see your idea?