276 results found
-
Incorrect capitalization of system functions
The SQL Prompt formatter incorrectly tries to capitalize (whether automatically while I type or using the formatter) system functions that are missing a database prefix. For example, SQL Prompt doesn't try to capitalize:
sys.fn_listextendedproperty
but it WILL capitalize
fn_listextendedproperty
as soon as I hit space, regardless of the CASE setting in SQL Prompt's options. Obvious, a capitalized FN_LISTEXTENDEDPROPERTY does not work: the function is case-sensitive.
There does not appear to be a way around this, not even by setting Format -> Styles -> Case -> Buit-in functions to "Leave as is". That only resolves the problem for the manual formatter:…
1 voteThis is fixed in the latest build of Prompt, if you’re still having problems please let me know.
-
Better work with temporary tables variables
The script below does not generate the correct sql syntax when adding a @table name into a subselect
DECLARE @temptable AS TABLE (recid INT)
DECLARE @mytable AS TABLE (contractid INT)
INSERT INTO @mytable
( contractid )
VALUES ( 1 -- contractid - int
)---> type @my -> then tab
--> the table is predefined with brackes wich is wrong for a @table
-> the below row is the resultSELECT * FROM @temptable WHERE recid IN (SELECT * FROM [@mytable])
11 votesThis case should be fixed in the latest release of Prompt (6.3). Let me know if you’re still having any problems with it.
-
Installing SQL Prompt 6 deletes old connection coloring options.
Installing SQL Prompt 6 deletes old connection coloring options.
Please Fix.3 votesSQL Prompt 6.3 will now upgrade the tab colouring options from version 5. SQL Prompt 6.3 can be downloaded from which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
However if SQL Prompt 6 has already run on the machine it will have created a new settings file which won’t be overwritten. To manually upgrade, copy servers.xml from “localappdata\Red Gate\SQL Prompt 5” to “localappdata\Red Gate\Red Gate\SQL Prompt 6”.
-
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/
-
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.
-
snippet isn't working correctly
When using snippet with version before 6 (5ish), I could just hit tab and it will give me the correct code. However, with version 6, sometimes (half of the time), the first choice is nothing. It will do nothing rather than giving me the code for that particular snippet. Please fix it. It's very frustrating.
2 votesHi Jay, I think this was fixed a while back but if you’re still encountering any issues with it let us know.
-
query history starts at Open Queries;
I would like a config open so that the dropdown of queries starts at OPEN QUERIES not all queries
also, I would like it when my mouse hovers over the magic tab button for it to just expand... the extra click makes it less magic
3 votesWe’ve released SQL Prompt 6 which includes this.
-
Case formatting
Case formatting to allow option of capitalising initial letter only - e.g. Select, not SELECT or select.
1 voteThe latest version of Prompt has the casing option UpperCamelCase which will case SELECT as Select.
-
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/
-
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/
-
More Matching in Intellisense
It would be nice to be able to extend the intellisense matching to skip things like underscores. For example, if the table was called cardpickupstaging, you could match it with pickupstaging or upstag.
4 votesThis is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/
-
What happened to the options settings for Tab Magic? I rarely, if ever, want the last tab opened and would like to be able to stop it
What happened to the options settings for Tab Magic? I rarely, if ever, want the last tab opened and would like to be able to stop it from doing so every time I start an instance of SSMS
2 votesWe’ve released SQL Prompt 6 which includes the tab magic options.
-
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.
-
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/
-
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/
-
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
-
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!
-
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/
-
Tab Magic EAP hijacks CTRL-T completely.
Do not hijack CTRL-T in Tab Magic. I routinely use this to direct query output to Text. I use this in concert with CTRL-D, for output to Grid.
Perhaps when options for Tab Magic are provided, we will be able to turn off this feature.1 voteWe’ve released SQL Prompt 6 which includes the ability to change the keyboard shortcut.
-
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.
- Don't see your idea?