63 results found
-
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.
-
Copy button on code popups in 6.0
I really like the new feature in 6 that allows Ctrl-C to work to copy sections of scripts. However, I am missing an easy way to copy the entire script from the code pop-up. The copy button use to do this when nothing was selected in the pop-up window. Restoring this functionality would be appreciated.
8 votesSQL Prompt 6.1 has now been released and has the copy button returned to the popup.
-
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/
-
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/
-
6 votes
We’ve just released SQL Prompt 6.1 which shouldn’t slow down SSMS with huge scripts.
-
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
-
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/
-
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/
-
Order suggestion columns name by table schema definition order (not alphabetically)
Add a flag to order suggestion columns name by column order (not alphabetically).
3 votesThe latest version of SQL Prompt 6.3 should show column suggestions by the table schema definition order.
-
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/
-
Snippet Template Fields
Enhance snippets to support arbitrary fields like Visual Studio or SSMS 2012.
So say I had the following snippet "dups" defined
SELECT *
FROM $tablename$
WHERE $columnname$ IN
(
SELECT $columnname$
FROM $tablename$
GROUP BY $columnname$
HAVING COUNT(*) > 1
);
I would type dups{tab}mytable{tab}mycolumn{enter}7 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Suggest only column names after a Table alias is typed in
If I have already typed in the alias name for a table, then suggestions after a period should always have the column names at the top. Sometimes, a code snippet shortcut or other unrelated item pops to the top of the list.
For example, if I am have typed in:
SELECT * FROM [sys].[tables] AS T
WHERE [T].isThen, the snippet for INFORMATIONSCHEMA shows at the top of the list. Since I already have put [T]., it should have the column names such as ismerged_published, etc. at the top of the list.
10 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Please add a function key to reopen the sqlprompt box.
Here’s what’s happening: I am typing along and I hit space instead of tab which does not complete the fill in (I actually like this so I don’t want to add the space as a completion key). I would like a mappable key combination to get the prompt to re-open.
2 votesCtrl+Space will bring back the suggestion box, but also the latest build of Prompt will bring it back if you just continue typing after you left off (if you didn’t purposely hide it with esc)
-
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/
-
Enable prompting within a raiserror()
For any attempt to use Intellisense within a RAISERROR() there is no prompting - list says "No suggestions".
Sample:
RAISERROR('Not at 12hrs UTC - time is %s',0,1,@<<Nothing-here>>) WITH NOWAITAlso reported as a defect on the SQL Prompt Forum
2 votesThe latest version of Prompt should give you suggestions within a RAISEERROR
-
Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows
Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows. This would be a very helpful feature to keep data types consistent throughout a database if one doesn't want to set up a user data type for each and every column that stores data types with additional parameters like, for instance, the scale and precision.
11 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 -
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/
- Don't see your idea?