270 results found
-
add semi colon to insertion keys
Could we have a check box to allow us to have the semi colon as one of the insertion keys (Main->Behaviour)?
It's not as common as the other keys there but when I'm about to finish a script I can't just hit the semi colon key.
12 votesWe’ve added semi colon to the list of insertion keys in 6.2 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Qualify column names with table aliases only
I would like an additional option for the Inserted code > Qualification tab:
Qualify column names with table aliases only.
Most times I want to assign a table alias and use it when adding columns, however if I forget to assign a table alias or remove it, I don't want a fully qualified table name when using the Qualify column names with table name option.
I would like the option to qualify with both table names and table aliases or just table aliases and NOT table names.
16 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Add ability to include earlier tables in the Join Clause
When writing a query that joins to several tables, the Join Clause only seems to look at the previos table to determine what columns can be used to join on. For example, when typing out the following query:
SELECT * FROM [dbo].[employee] AS E
INNER JOIN [dbo].[Department] AS D
ON [E].[DepartmentID] = [D].[DepartmentID]
INNER JOIN [dbo].[Position] AS P
ON ...When I look at the options for the ON clause for the join to Position, it doesn't include any columns being joined back to the Employee table. It would be nice if the suggestions would include at least any foreign…
41 votesWe’ve released SQL Prompt 6 which includes all tables in a join clause.
-
Ability to flip the sides in an auto generated join clause
When I write a join statement I put the last table that I am joining to the other tables on the left side of a join clause. For example:
SELECT *
FROM tblOrder o
INNER JOIN tblIOrder_Detail d
ON d.OrderID = o.OrderID
The auto-generated join clause would be "ON o.OrderID = d.OrderID". It would be nice if it was possible to customize this behaviour to choose which side there will be each table/alias on.Thanks
27 votesWe’ve released SQL Prompt 6 which includes an option to swap the order of columns in join clauses.
-
XML Data Type method layout SQL support
Can not use SQL prompt to layout XML data type functions, for example this statement:
SELECT(SELECT 1 Col
FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)')3 votes -
select column names
after typing select and adding table name the popup box that shows the table summary (column names and their types); if these rows(column names) be clickable, select columns could be filled from that list instead of typing.
3 votesSQL Prompt contains a “Column Picker” feature that should do what you’re requesting.
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 -
toggle SQL Prompt from toolbar
I frequently need to work on longer procedure or scripts, and the longer the script gets Sql Prompt gets more and more bogged down, to the point I just turn it off. It would be nice to be able to toggle it from the toolbar rather than open the options to un-check 'Use SQL Prompt'
6 votes -
Column aliases alignment
Allow alignment of column aliases in a Select statement.
22 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!
-
Provide support for CLR functions
The object text exists as normal for CLR functions (or at least enough for provide auto suggest on object name and number of params and types), therefore please can function which are backed by CLR be available in the suggestion list
47 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Moving commas from "end" to "start" is always buggy when comments exist
Moving commas from "end" to "start" or vice-versa is buggy when comments exist after each column or parameter. This is an issue regardless of the type of statement (SELECT, INSERT, UPDATE, CREATE TABLE/VIEW/FUNCTION/STORED PROCEDURE, etc).
Here is my original SP with commas at "end" followed by comments (hyphens are used for indentation due to HTML formating issues):
CREATE PROCEDURE dbo.MyProcedure
---- @Param1 int, --Param1 comments
---- @Param2 int, --Param2 comments
---- @Param3 int --Param3 comments
AS
BEGIN
---- SELECT Col1 , --Col1 comments
---- ---- Col2 , --Col2 comments
---- ---- Col3 --Col3 comments
---- FROM MyTable
---- RETURN
END…16 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!
-
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/
-
Format SQL to Match Object Case
If I had the table [Address] that had the columns StreetAddress1, StreetAddress2, City, State and ZipCode defined and the following existing code was formatted:
SELECT streetaddress1,
streetaddress2,
CITY,
zipcode
FROM [address]I would like to see SQL Prompt match the case of the underlying object such that the results after formatting would be:
SELECT StreetAddress1,
StreetAddress2,
City,
ZipCode
FROM [Address]This should apply to all underlying objects (procedures [name and parameters], tables [columns, index names (used in hints), etc., functions and views; and anything else I forgot). It should also apply to variables defined within a procedure (e.g. DECLARE @MyValue…
63 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Create more $...$ placeholders for snippets
I would like to see additional placeholders for the snippet manager. For example $DBNAME$, $SERVER$, $PASTE$ (already suggested). A format option for $DATE$ and $TIME$ would also be nice (e.g. $DATE(mm/dd/yyyy)$ $TIME(hh:mm:ss24/hh:mm:ssA/hh:mm)$, etc.).
39 votesWe’ve released SQL Prompt 6 which includes several new placeholders.
-
Refactoring INSERT into UPDATE
I wish there where a shortcut/command to change a statement like
INSERT INTO Mytable(Id,Code,Label) VALUES (@Id,@Code,@Label)
in
UPDATE MyTable
SET Id=@Id, Code=@Code, Label =@LabelEven if it looks trivial on this statement, doing it with a table with 10+ Columns might be cumbersome.
79 votesWe’re happy to announce that this feature is now included in SQL Prompt 9.3. For additional information see: http://documentation.red-gate.com/display/SP9/SQL+Prompt+9.3+release+notes.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
Thank you for your help!
Kind regards,
The Prompt Team -
I would like to export results to Excel directly
In the result window, right click and select all and have an option to export selection to Excel (new spreadsheet) or to an open spreadsheet at the current location.
3 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Highlight the invalid objects within the Alter script(s)
Highlight the invalid objects within the Alter script(s)
7 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
intellisense for SQL functions
In Visual Studio 2010, when I type in a function name and then the open paranthesis, I'm shown some intellisense that tells me what type of parameters I need to type in. For example, if I type (using VB.Net) "Dim da as Date=DateAdd(", it tells me the first paramter is "Interval as Microsoft.VisualBasic.Interval", and so forth. It would be nice if SQL Prompt did this for built-in (or even user created) functions, e.g. the DATEADD SQL function. I can never remember exactly the parameter sequence of that function, and it would be nice if SQL Prompt showed me like VS…
12 votesSQL Prompt already did this, but there was a bug with certain built-in functions, including DATEADD(), that prevented the tooltip from appearing. This is now fixed in SQL Prompt 5.2.
-
More options for saving results from grid
When saving results from the grid in SSMS the only option is to csv. It doesn't include headers and if your data has commas in it, the csv file becomes formatted incorrectly. An option to go to excel, or a tab delimited txt file, or choosing the delimiter would be useful.
1 voteSQL Prompt 7.1 includes an “Open in Excel” context menu item. You can download the latest version 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
-
wildcard
A wildcard search when
select * from <tablename> now we only see table names starting with the key, but it would be very nice to have the exist in it as well.
so tra -> will result in traffic but also mytraffic3 votesThe latest Prompt has partial matching for suggestions
- Don't see your idea?