275 results found
-
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 -
Auto generated INSERT statement is buggy with commas at start
The auto-generated INSERT statement BADLY MISALIGNS data when "Place commas at start" is enabled. I've listed all the settings to reproduce the issue at the end of this post.
The comma and associated info are on a separate line (almost useless - Worse when I need to delete some of the columns). See this example (generated by SQL Prompt Pro 5.1 - hyphens represent tabs due to HTML limitations):
INSERT INTO dbo.Test
---- (FirstName
---- , LastName
---- , LocationAddress
---- , LocationCity
---- , LocationState
---- , LocationZip)
VALUES (''
---- , -- FirstName - varchar(100)
---- ''
----…11 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Shortcut for Switching Styles
Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?
I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.
Thanks for your consideration!
Lawrence Barnes
10 votesWe’ve released support for quick switching of active styles in version 8 of SQL Prompt. You can right click in the editor window, select `Active Style` and then choose the style you want to switch to.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If you are still keen to have this functionality available via a hotkey, please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
Remove extra space between statements option is Needed
SELECT
*
FROM
Temp1--Remove this kind of extra spacing between statements option is Needed
SELECT
*
FROM
Temp2--Remove this kind of extra spacing between statements option is Needed
SELECT
*
FROM
Temp310 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!
-
Fix SQL Case Formatting - Consistent Casing
I have been sent a large database schema create script from a legacy system.
The schema has been written in a case insensitive way.
So for example any variables in the stored procs in this create script have been written in multiple cases:
@pvariableNameOne
@pvariablenameOne
@pvariablenameOne
@pVariablenameOne
etc....The database was originally hosted on a Latin1GeneralCIAS Collation at server and database level.
The new hosting environment has been set to Latin1GeneralCSAS at server level, making it case sensitive.
Although we can set the database to Latin1GeneralCI_AS to make…10 votesThis is included in SQL Prompt 6.4, which you can download 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/
-
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/
-
Insert Snippet Via Right Click
Really like snippets, but sometimes I'd prefer to add a snippet by looking through the list of those available.
Snippet shortcuts work well for things I do all the time, but I'd like to be able to use it as a repository for useful sql, and would therefore like a different way to insert, ie, via right click menu or even from the menu bar.
10 votesWe’ve made several improvements to snippets including new insertion options.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
Here is the documentation for how to insert snippets using the various available methods: https://documentation.red-gate.com/sp9/speeding-up-your-queries/inserting-snippets
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
ST008
I'd like to vote for adding ST008 (non-named parameter style used) to the issues which can be auto-fixed. Hopefully it would be fairly simple to implement.
9 votesHi,
We’ve released this autofix in SQL Prompt 9.5.13.11024. Please let us know what you think!
Thanks,
The Prompt Team
-
Format SQL - quick styles
I want to switch between TEAM and PERSONAL styles for Format SQL. It currently takes 8 mouse clicks to achieve this. Could you add a style lookup on the context menu or Red Gate tools menu and apply the style to the current document automatically as soon as it is selected.
I want my team to be able to work in their personal SQL format, but always save in the TEAM format.
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!
-
semi colon placed on new line
Place semi-colon on new line.
I frequently format my statements as I'm developing them, but multiple times now I've started to add an Order By or some other clause after the auto-inserted semi-colon. I would like to see an option to place the semicolon on the line following the sql statement rather than directly after. This would enable me to start typing at the start of the next line without having to check if a semicolon had been added to the preceding line.
Example:
Select * From Table
Where A = 1; -- Semicolon added by formatting
Order By A9 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!
-
Add Comment Block to Surround With choices
Can you add a comment block /* */ to the Surround With choices? It would be of great use.
I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.
The example one person gave was Surround With ISNull( <highlighted column> ,0)
9 votesSQL Prompt 7 includes a $SELECTEDTEXT$ snippet placeholder which allows you to create surround with snippets that can be used through the Actions List (it also has a comment feature that’ll add — to the start of every line). You can download the latest build from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Give Format SQL the ability to convert X.Field1 AS NewFieldName format to FieldName = X.Field1
We have a lot of legacy code that is written as
SELECT Field1 as Name1, Field2 Name2 FROM Table X
(Sometimes they use AS when setting the alias, othertimes they do not).I would love the ability to convert this to
SELECT
Name1 = X.Field1
, Name2 = X.Field2
FROM Table XBoth having the ability to switch between Name = Value and Value AS Name and to auto add the alias to all fields.
9 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 -
2014 ctp2 support
please add support for sql 2014 ctp2, i'm already using it and im sure others are as well and quite frankly i've grown very accustomed to using sql prompt that it became quite hard to work without it.
i hope you can add the support really soon
9 votes -
Smart alias rename
It would be really nice to have a smart rename for aliases.
Example:select c.ID, c.Name, a.*
from Customers as c
join Adress as a on c.adressid = a.adressidUsage: I select alias "c", click right mouse(or shortcut) and choose Smart Rename and the new aliase should be changed everywhere I use it.
9 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Option to align AND predicates with WHERE
Would love to be able to have all predicates at the same indent level ie:
WHERE something = yetsomethingelse
AND somethingelse = anotherthing9 votesWe’ve released support for formatting options such as this in version 8.0 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
-
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)
-
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/
- Don't see your idea?