276 results found
-
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/
-
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/
-
Query Execution History
Had this with SSMS Tools Pack but upon migrating to 2012 I ditched it in favor of SQL Prompt. The only thing I'm missing is a log of my Query History, time-stamped and searchable.
106 votesWe've now released this feature in version 10.13
-
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/
-
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/
-
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.
-
One line SQL from context menu - Opposite if Format SQL
Have a function which is the opposite to 'Format SQL' so you can select a section of text and have all the Line Breaks and padding taken out. Currently I use HTML Shrinker Pro to do this, but it would be nice to select a block and one line it eg..
@DateAppointed = CASE WHEN LEN(DateAppointed)> 1 THEN DateAppointed ELSE @Unknown END ,2 votesSQL Prompt 7 has an “Unformat” action in the new Actions list. The full release notes can be found here http://documentation.red-gate.com/display/SP7/SQL+Prompt+7.0+release+notes
-
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.
-
Format SQL so keywords are right aligned
SELECT Number1
,Number2
,Number3
FROM table r
JOIN table2 tf
ON r.column = tf.column
AND r.column = 0
WHERE column = 0
AND column1 = 22 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 -
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
-
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/
-
Enable support for SQL PROMPT in VS 2012
Currently no love for VS 2012 - hurry, please!
9 votesSQL Prompt 5.3.6 was released in October 2012 with support for Visual Studio 2012.
-
Rowversion or timstamp column
When a column is defined as rowversion or timestamp, please automatically exclude it from insert table column list.
6 votesThis is fixed in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Snippet Template Fields
Enhance snippets to support arbitrary fields like Visual Studio or SSMS 2012.
So say I had the following snippet "dups" defined
SELECT *
FROM $tablename$
WHERE $columnname$ IN
(
SELECT $columnname$
FROM $tablename$
GROUP BY $columnname$
HAVING COUNT(*) > 1
);
I would type dups{tab}mytable{tab}mycolumn{enter}7 votesThis is included in SQL Prompt 7 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 -
Suggest only column names after a Table alias is typed in
If I have already typed in the alias name for a table, then suggestions after a period should always have the column names at the top. Sometimes, a code snippet shortcut or other unrelated item pops to the top of the list.
For example, if I am have typed in:
SELECT * FROM [sys].[tables] AS T
WHERE [T].isThen, the snippet for INFORMATIONSCHEMA shows at the top of the list. Since I already have put [T]., it should have the column names such as ismerged_published, etc. at the top of the list.
10 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
anywhere in the script file if the last line below is used it causes an error. CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WI
sequences in sql 2012 is not supported by the formatter
anywhere in the script file if the last line below is used it causes an error.
CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WITH 1 INCREMENT BY 1 NO CYCLE CACHE 10
go
DECLARE @Seq INT
SELECT @Seq = NEXT VALUE FOR [dbo].[ReportComparisonSeq]4 votesThis 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?