276 results found
-
Add support for spatial functions/methods
Need Intellisense for the spatial functions and geography/geometry data types, especially since they are case sensitive, and annoyingly a mixture of upper and lowercase.
7 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Ability to set "Show schemas" as the default option for the candidate list
When object names appear in the candidate window for an autocomplete, the schemas are not shown by default. Clicking on the the arrow in the bottom left of the window will show them, but this setting is not remembered so you have to do it each time. Also there's no keyboard shortcut that I can find to do this. Add the ability to set this popup to show the schema names by default.
7 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
format join
I would like the ability to get Format SQL to handle my JOIN formatting - I like to have my JOINs look like this:
SELECT
(columns)
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECTID = i.objectidThat is: I want to have my tables being joined lined up with the (intended) table in the FROM clause, and I like to have my JOIN condition on the same line as the joined table.
Right now, I cannot seem to get this to work - the table name and join condition are always stuck onto the same line as…
7 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 -
Enhance the Format SQL to recognize the WITH clause.
When the WITH clause is specified in the FROM clause on a JOIN, Format SQL pushes the join condition out to the WITH.
Like this:
FROM
TableA WITH (NOLOCK)
JOIN TableB WITH (NOLOCK)
ON TableA.ID = TableB.IDI would like it to behave like it does when the WITH is not present
FROM
TableA WITH (NOLOCK)
JOIN TableB WITH (NOLOCK)
ON TableA.ID = TableB.ID7 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Highlight the invalid objects within the Alter script(s)
Highlight the invalid objects within the Alter script(s)
7 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add $SUGGEST$ placeholder in snippets
I would like to see an additional placeholder, maybe called $SUGGEST$, added to the snippets. This placeholder would position the cursor like $CURSOR$ and bring up the suggestions as if you hit CTRL-space. This would resolve an annoying issue that some of us see with our SSF snippet when we have a space after the FROM clause, and we are then required to hit CTRL-space to bring up the suggestion after expanding the snippet. (See forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?t=12423)
7 votesAs of SQL Prompt 5.2.8, the suggestions list will pop up automatically after a snippet insertion — if it would be sensible to do so (e.g. if the list would normally pop up if you typed the snippet out by hand).
-
Aliases - also enclose with square brackets []
using the example
SELECT patientid FROM PTGEPATIENT AS pgpIf I qualify object names (ctrl-B, ctrl-Q), I will get
SELECT [pgp].[patientid] FROM [dbo].[PTGEPATIENT] AS pgp
The alias is not enclosed in square brackets after the "AS" keyword. Would like to see that support for consistency (this is the standard I currently have in place)
7 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Improve formatting of parameter layout
SQL Prompt 5 does not behave the same as SQL Refactor when it comes to formatting parameters that may be passed to a function, stored procedure, etc. You can increase the text wrapping, but that is not a full-scale solution. A better solution would be to allow you to want to align the parameters on new lines or put all parameters on one line ignoring the text wrapping limit.
7 votesWe’ve released a brand new formatting system in version 8 of SQL Prompt and have made further improvements since.
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
-
Date time types default to UTC and cannot be changed
Whenever I use the INSERT INTO template in SQL Prompt 5, I get an incorrect date and/or time inserted for all date/time columns detected in the table. The time is 8 hours ahead of my time zone. I am on Pacific Standard Time, thus running the INSERT INTO template at say, 4pm, will generate a default date/time stamp of the next day at midnight (2011-01-06 16:00:00 real time produces a default insertion of 2011-01-07 00:00:00 for all date/time column values in the proposed INSERT statement). My assumption is that the default time is set to UTC which makes sense for…
7 votesPrompt 6.3 uses GETDATE() rather than inserting a string literal with the current date
-
Enhancement to "Warning on delete and update statements if no WHERE clause is specified" (clarified)
This is a clarification to an earlier post. (https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/13543761-enhancement-to-warning-on-delete-and-update-state)
This is a great idea, but I was surprised by the number of "false positives" I am getting (and yes, I can just mute the messages completely).
In my case I am doing a lot of updates/deletes on permanent tables with joins to temporary tables or table variables and that limits the update/delete scope.
Can you add to this feature so that messages will not be emitted if there is a join to a temporary table or table variable?
For example...
Update dbo.RealTable
Set SomeData = tt.SomeData
From dbo.RealTable…6 votesThis feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Search for Snippet Manager
I have a lot of snippets. It would be great to have a search feature to find the snippet I'm looking for to edit it or see that I have it.
6 votesWe’re happy to announce that this feature is now included in SQL Prompt 9.1.3.4467. For additional information see: http://documentation.red-gate.com/display/SP9/SQL+Prompt+9.1+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!
Kind regards,
The Prompt Team
-
Remove Red Gate toolbar
This is an old problem that just won't go away.
The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.
Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.
Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).
6 votesHi all,
Thanks for your help tracking this down! I’ve made a fix for the permission issue here:
http://download.red-gate.com/EAP/SSMSIntegrationPackFramework/SSMSIntegrationPackFramework_1.0.31.0.exe
Which should work without having to run as an administrator. We’ll look into getting this included in the SQL Search and Developer Bundle installers.Thanks,
Aaron. -
Formatting SQL Transaction
It would be nice to have the code within a BEGIN TRAN and COMMIT be indented.
BEGIN TRAN
<ssss>INSERT....
<ssss>UPDATE....
COMMIT TRAN6 votesWe’ve released a brand new formatting system in version 8 of SQL Prompt and have made further improvements since.
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
-
Delay before Suggestion dropdown [Bring it back]
I used to have a couple hundred milliseconds of delay in here. This was really helpful in some circumstances to allow me to do down a line of text adding tabs, spaces, commas, etc. (all kinds of things to satisfy my obsessive need for proper formatting). Without this option I now have to hit [ESC] each time to clear the suggestion box no matter how quick I move down, making this an annoyance.
6 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Option to unformat onto a single line
Often when I'm debugging code that dynamically generates SQL, I hit a breakpoint, then copy the code into an SSMS query window. All the code is typically in a single long line. I can then use SQLPrompt to format the code to read it, and potentially change it to correct errors. However, what I then often want to do is to paste the changed code back into the variable (or whatever). I'd love to be able to have an option to format the code all into a single line.
6 votesThis is included in SQL Prompt 7 which you can download 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.
-
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/
-
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/
-
Add support for the ROWS|RANGE clause (part of the OVER clause enhancements) in SQL Server 2012
SQL Prompt does not recognize the new ROWS | RANGE keyword additions to the OVER clause in SQL Server 2012
6 votesROWS and RANGE are supported in SQL Prompt 6
-
SELECT DISTINCT starts new line and loses indentation; keep SELECT DISTINCT on same line please.
I believe the DISTINCT keyword should remain on SELECT line but at least maintain the indentation please. Thanks
6 votesWe’ve released support for this piece of formatting in version 8 of SQL Prompt.
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
- Don't see your idea?