276 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.
-
Execute current statement/block
It would be greate if you could make an option to Execute current statement/block/all staments from top to current stament (current=where the cursor located) when clicking Ctrl + Alt + F5/Ctrl + Shift + F5/Alt + Shift + F5.
So, if the the cursor located in a the middle of long script, and I'm clicking Ctrl + Alt + F5 it will execute the currnt statment like if I would have select the current statement and click F5.
Same for Ctrl + Shift + F5 and Current block and for Alt + Shift + F5 and all staments from top…43 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Support SQL Azure
Bring in support for SQL Azure for the application. If there are limitations where it cannot be done for Azure, possibly allow the user to set a local database as the model for an azure database to build the cache.
43 votesThis was shipped in v10.4.
Thank you for your input!
Chiara
-
Support a common intending option for SELECT
Sample query (spaces marked with underscores):
SELECTstaffId, staffName, a
FROM__personnelSELECT and FROM have whitespace after them to align the rest of the statement. This formatting style is tedious to maintain and almost nowhere to be found in real codebases or on the web. Please support the more common code style:
SELECTstaffId, staffName, a
FROMpersonnelJust one space.
41 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!
-
Add ability to include earlier tables in the Join Clause
When writing a query that joins to several tables, the Join Clause only seems to look at the previos table to determine what columns can be used to join on. For example, when typing out the following query:
SELECT * FROM [dbo].[employee] AS E
INNER JOIN [dbo].[Department] AS D
ON [E].[DepartmentID] = [D].[DepartmentID]
INNER JOIN [dbo].[Position] AS P
ON ...When I look at the options for the ON clause for the join to Position, it doesn't include any columns being joined back to the Employee table. It would be nice if the suggestions would include at least any foreign…
41 votesWe’ve released SQL Prompt 6 which includes all tables in a join clause.
-
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.
-
Create more $...$ placeholders for snippets
I would like to see additional placeholders for the snippet manager. For example $DBNAME$, $SERVER$, $PASTE$ (already suggested). A format option for $DATE$ and $TIME$ would also be nice (e.g. $DATE(mm/dd/yyyy)$ $TIME(hh:mm:ss24/hh:mm:ssA/hh:mm)$, etc.).
39 votesWe’ve released SQL Prompt 6 which includes several new placeholders.
-
Import and Export all SQL Prompt options
It would be nice if there was a way to import and export all SQL Prompt options like how you can import and export format styles.
39 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Expose all formatting options in the UI
There appears to be several items (BEGIN and END tabbing, table declaration placement, number of tabs for the join condition...etc.) that happen automatically when you click Refactor that Format SQL that you can't configure in the UI.
39 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!
-
marker on pairs of BEGIN and END on code
marker on pairs of BEGIN and END on code
38 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Generate Scripts Based on the Result Grid
Just like in Toad and SSMSBoost, there's a facility to create a script such as INSERT based from the given result grid. This would be handy in generating test data or re-populating tables
37 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
inserted and deleted tables should be supported in triggers
There is currently no support for the 'inserted' and 'deleted' tables within triggers. They should be treated as equivalent to the original table that the trigger is attached to.
37 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Support for XML functions
The XML data type methods are CASE-SENSITIVE - so SQL Prompt must NEVER EVER uppercase those! I have been requesting this feature for a long time. Please fix this.
37 votesWe’ve released SQL Prompt 6 which includes support for XML functions.
-
Disable auto update check on startup
It would be nice if we can turn off the auto update check for a new version on start-up. This check is happening in the Visual Studio database project and in SSMS. I'd like to disable it. Thanks!
36 votesIn Prompt 10.0.11 we added a new option to the help menu called ‘update notification frequency’. This will allow you to reduce the frequency of updates all the way down to major versions only (one update a year).
-
Partial Name Matching (like the Intellisense in VS2010)
I thought that partial matching for Intellisense was a rubbish idea, but after using in VS2010 I find it absolutely indispensable, and I really miss it in SQL Prompt.
[b]What is it?[/b]
An example:
[code]
CREATE TABLE [dbo].[Clients](
[ClientID] [int] NOT NULL,
[ClientName] [varchar](50) NOT NULL,
[ClientSurname] [varchar](50) NOT NULL,
[ClientCardNumber] [int] NOT NULL
) ON [PRIMARY]
[/code]If I had to now type
[code]
SELECT
ClientID,
ClientName,
ClientSurname,
ClientCardNumber
FROM
dbo.Clients AS c
ORDER BY
$CURSOR$
[/code]
and started typing "Cli" I would get a list of all the column names on the table. However, if I typed "ID"…36 votesAs of SQL Prompt 5.3, partial matching is now included for everyone.
-
Turn off notifications such as "Slow cached time detected".
Have the ability to turn off notifications such as "Slow cached time detected". I see it every time I connect to a database - and I work with every element in the db's so I want it all to be cached. But I do not want to see this notification every single time.
34 votesI’m pleased to say SQL Prompt 9.5.13 has just been released, which allows you to dismiss a notification forever. The next time you see “Slow cache time detected…” just click the ‘x’ and the product will never show that notification again.
You can download that version from http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.5.13.11024.exe.
Please get in touch if you have any other issues.
Thanks
Tom
Team Prompt -
Allow me to specify schemas to include or exclude
The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.
34 votesWe added schema filtering in SQLPrompt 9.4.15. You can learn more about the feature here: https://documentation.red-gate.com/sp9/managing-sql-prompt-behavior/managing-connections-and-memory
We would love to hear your feedback.
-
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/
-
Jump to object explorer
I just had a situation where I was in code, didn't have the object explorer opened up for the connection and wanted to look at the table properties, security etc.
It would be really good if you good offer up a "go to object in object explorer" feature - similar to the F12 shortcut to load an ALTER tab, but just changes the object explorer focus to the object that I am currently at.
29 votesThis is included in SQL Prompt 6.3, which can be downloaded 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!
- Don't see your idea?