275 results found
-
Show Long file names in Query History in Tool Tip
Hi,
Thanks for your last changes!
In addition, I have sometime Long file names where only looking on their Name tail or according to their full path, I can decide which one is the relevant.
Could you add in Query History a Tool Tip when hovering above the File Name with Full Name, Path, Last Closed, Last Connection details, etc.?THNX
Jermy1 voteWe’ve released SQL Prompt 6 which includes this.
-
Bulk Delete old tabs
It would be great to be able to bulk delete old or unneeded tabs from Tab History. Right now, I have to delete it one by one which is an endless task.
8 votesWe’ve released SQL Prompt 6 which includes this.
-
SQL Tab Magic - When searching query history the text in the preview pane jumps to the left
Hi,
First, I like the new design, and thank you for make it available for SSMS 2012.
I have 2 problems:
1. I missing the Option button (I don't wont it to open recently closed queries on start-up).
2. When I'm searching for term in the Query History dialog, and hovering above one of the files in the left pane, its query text in the preview pane jumps to the somewhere in the file and move a bit to the left. I assumes it suppose to jump to the first match, but, it is not always even in the frame.…3 votesWe’ve released SQL Prompt 6 which includes a fix for these.
-
Recognize double quotes for object names in the same way as square brackets.
Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.
For example, typing:
SELECT * FROM [MyTable]
will allow the expansion of the asterisk, while
SELECT * FROM "MyTable"
does not.SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".
1 voteThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Unwrap sp_executesql
Frequently I need to debug application generated SQL obtained via Profiler. Parameterized queries are often implemented with sp_executesql.
I love using Format SQL to make a single line monster query into something I can actually read. But when it's stuck in an spexecutesql call the format function doesn't touch it. I have to:
Remove "Exec spexecutesql".
Remove the apostrophes around the query SQL. For big queries this is really painful, especially if the query itself contains apostrophes.
Remove the apostrophes around the parameter defenitions.
Move the parameter definitions to the top and add a DECLARE.
Move the parameter…18 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 -
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/
- Don't see your idea?