276 results found
-
Autoformat should not indent begin
Instead of
IF xxx
BEGIN
sss
sss
ENDIt should format as
IF xxxx
BEGIN
ssss
ssss
ENDfor all cases where begin and end are used.
18 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
inserted and deleted tables should be supported in triggers
There is currently no support for the 'inserted' and 'deleted' tables within triggers. They should be treated as equivalent to the original table that the trigger is attached to.
37 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 system stored procedures
I just needed to re attach a database from a single mdf file. Something I do every 6 months or so and every time I have to google the command and its syntax. Would be helpful so SQL Prompt recognised and helped with these and other inbuilt procedures and their parameters, for example:
spattachsinglefiledb
sp_helptext
spattachdb
23 votesIn 6.4 we always provide intellisense for system stored procedures if the query is being run against master.
If you’re running against a normal db then we hide the system stored procedures by default as they clutter the suggestions list. There’s a couple ways to get around this, either by qualifying with “sys.” or using the “List system objects” option. A video on this can be found here https://www.youtube.com/watch?v=i8DOTmHkKo8
-
Option to sort column lists by table order as rather than alphabetically
Have an option to sort the column list as it appears in the table rather than alphabetically. I have a good memory for where the functionality sits in the table, but I don't always remember the name. Columns are often logically placed in the table.
3 votesSQL Prompt 6.3 will display the columns in their table order rather than alphabetically
-
Extend the column toolstips with the nullable attribute
Extend the column toolstips with the nullable attribute, like this "ic.Attachment varchar(max) not null (Column)"
4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Qualify Object names and brackets
I recommend splitting the two as distinct user settings. Qualify objects should have two options: Always and Only When Necessary. The reason is that in many cases, such as a simple select from one tabe, table name in front of each field is simply clutter, adding no value. I fact, I remove them manually, as I am more interested in brackets than qualifying object names.
Brackets setting (new seeting) should have a simple Yes/No option - When set to Yes, for consistency, I recommend using brackets even in aliases (another user requested this already).
Other thant the above, SQL Prompt…
4 votesSQL Prompt now has separate settings for Qualify Object Names and Add/Remove Square Brackets, which hopefully is what you’re after.
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
-
Invert Aliasing
As you select a Table say LotBaseLog , we get auto aliasing to give
Select * from LotBaseLog as lbl
What about using the alis in reverse
Select * from lbl
Gives
Select * from LotBaseLog
Have a look at Resharper Camel Hump principal
Maybe an even better shorthand
Mike
2 votes -
Lower-Case Keyword Support in Format SQL
Support lower-casing keywords instead of upper-casing them; this makes reading the query far easier as the app-specific bits are more visible
4 votesThis already exists as an option in SQL Prompt
-
CTE Support
It would be nice if SQL Prompt could parse CTE expressions and provide prompts just like for regular tables
14 votesThis issue has been reported non-reproducable in recent versions of 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.
-
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/
-
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 -
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/
-
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.
-
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!
-
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 -
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!
- Don't see your idea?