270 results found
-
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/
-
Support MERGE
SQL Prompt sometimes works on some parts, e.g., it will give a list of columns for MATCHED but only for the TARGET table, never the source... It also suggest tables when coding a list of columns for an INSERT or it quits making any suggestions at all. This is a very hit-and-miss situation and very frustrating.
As the MERGE statement has been around since SQL Server 2008, it's very surprising/disappointing that, considering MERGE to be a STANDARD part of the DB Engine, SQL Prompt is this far out of date... FOUR YEARS AND COUNTING...!
Please "get current" :-)
28 votesWe’ve improved MERGE statement suggestions in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
Please let us know if you have any examples where you think suggestions could be improved!
-
comment block
I would like a feature to place a hilited block of code into a comment block /**/ - rather than having inline comments (helps when capturing the running sql in monitoring tools)
4 votesThe latest version of SQL Prompt has the $SELECTEDTEXT$ placeholder which allows you to use the current text selection in your snippets. So to surround a selection with a comment block you could create a snippet similar to:
/*
$SELECTEDTEXT$
*/ -
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)
-
SqlPrompt doesn't understand the Syntax of an update-statement when the table-to-be-updated is aliased
Hi!
Please consider this statement
update t1
set t1.value = t2.value
from Table1 t1
join Table2 t2
on t1.ID = t2.IDWhen you have the cursor in the set-block of the statement, SqlPrompt doesn't know what 't1' means and which columns t1 has.
30 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
SQL Tab Magic - Connection attempts
When loading management studio it would be great if tab magic could get a list of the required connections before the tabs are loaded and test each one silently to see if a connection would be possible (i.e. host is available) If the host is available then prompt for login once per host, if host is not available simply load the tab as not connected.
This would make the experience much nicer as at the moment if I had say 15 tabs open to a host that I am no able to connect to (I work on multiple sites) I…
8 votesSQL Prompt 6.1.0.71 will try a silent background connection before getting SSMS to connect the query.
-
SQL PROMPT 5 - Simple, but toggle indenting of else if statements
Allow the option to NOT indent else if statements. Each of the ELSE IF statements gets further indented and for large SQL it becomes indented off the screen. I can imagine this pattern could apply else where but for this specific use case our STPs that have this condition i simply can't format the sql because it requires me to horizontally scroll. Allowing me to disable indenting ELSE IF statements would solve this problem instantly.
21 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!
- Don't see your idea?