270 results found
-
Unformat SQL
It would great if there was an un-format SQL command, which would basically un-format the SQL by removing all the carriage returns, tabs, extra spaces, etc. I know it seems odd, but we have several applications that use the SQL via external files, so the formatting will not work, and we end up manually removing all the formatting.
7 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
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/
-
Improve "read ahead" for variables
I find that in longer stored procedures, declared variables often don't show up as I start to type them. E.g. typing @ towards the beginning of the sp shows me a list of the variables, however if I'm further down in the proc, they ofter are not listed.
15 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Surround templates added to snippet manager.
So you could highlight a column and surround it with isnull() for example.
Or surround a sql query and surround it with begin and end.11 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.
-
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/
-
Code sniffing
Hows about Code sniffing? For checking code compliance with user defined standards. Like checking column names conform to a defined standard, warnings on bad practices etc. You know all those little annoying things like no clustered index, use of cursors instead of set based ops, use of Select * or of Insert into tableA values (a,b,c).
All driven by user defined rules? With larger dev teams the standards docs always left to the side. If it could work on input and in some sort of batch mode (on sql source control check in?) it would be nice.
I've been looking…
14 votesWe’re happy to announce that we introduced code analysis in SQL Prompt 9+. For additional information see: https://documentation.red-gate.com/sp9/analyzing-your-code
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If you have any ideas regarding improvements to Prompt’s code analysis, please feel free to open further UserVoice requests.
Thank you for your help!
Kind regards,
The Prompt Team
-
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/
-
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)
-
Format CTE
Allow users to specify how CTEs should be formatted. Right now I get:
WITH cte
AS (
SELECT
Title
,FirstName
,LastName
FROM
isales.dbo.salesteam
)
SELECT
Title
,FirstName
,LastName
FROM
cteWhat I would like is:
WITH cte
AS
(
SELECT
Title
,FirstName
,LastName
FROM
MyTable
)
SELECT
Title
,FirstName
,LastName
FROM
cte26 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!
-
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 -
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/
-
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
-
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/
- Don't see your idea?