276 results found
-
Inserting the AS keyword for aliases
It would be nice if one could click a button and get the AS keyword between an object name and its alias. This would help with code that doesn't use AS to separate the two. And would also help readability.
Thanks.
4 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 -
Tab Coloring
Had this discussion with some folks at work today. SSMS Toolspack does tab coloring but it places a color band across the entire width of the query editor while SQL Prompt's tab coloring only colors the tab. The whole line is a much more obvious reminder. Be great if SQL Prompt did a similar thing. I realize Tab coloring is an experimental feature still.
4 votesSQL Prompt 7 colors the status strip which covers the entire width of the editor. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Search Middle of Snippet name
Intellisense should find snippets where characters appear anywhere in the snippet name, not just at the beginning. I have 2 or 3 dozen snippets and I can't always remember what the less frequently used snippets are called. For example I might several snippets that deal with space usage, but some are named like this: "getSpaceUsage". It would be useful if typing "space" found all snippets that contained space anywhere in the name not just at the beginning.
4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Grant no longer suggests Domain users or groups
When typing a GRANT statement I no longer suggestions after the "TO" for domain users or groups that exist in the database. I only get SQL Users.
Please include all users in "Security\Users" after the "TO" in the GRANT statement intellisense.
4 votesThis is fixed in SQL Prompt 7 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/
-
4 votes
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
anywhere in the script file if the last line below is used it causes an error. CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WI
sequences in sql 2012 is not supported by the formatter
anywhere in the script file if the last line below is used it causes an error.
CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WITH 1 INCREMENT BY 1 NO CYCLE CACHE 10
go
DECLARE @Seq INT
SELECT @Seq = NEXT VALUE FOR [dbo].[ReportComparisonSeq]4 votesThis is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
comment block
I would like a feature to place a hilited block of code into a comment block /**/ - rather than having inline comments (helps when capturing the running sql in monitoring tools)
4 votesThe latest version of SQL Prompt has the $SELECTEDTEXT$ placeholder which allows you to use the current text selection in your snippets. So to surround a selection with a comment block you could create a snippet similar to:
/*
$SELECTEDTEXT$
*/ -
Turn Off Schema Collection
I'd like to enable schema collection when I'm writing code, and disable it when I'm doing adhoc queries. Why: We have 100 identical databases with 1900 tables in each database. When I run a query that pulls data from each database sqlprompt starts collecting schema data from all 100 databases, then it runs out of memory and crashes.
The "Turn Off Prompting" option does not help.example:
select id,customer from DB1.dbo.orders where date > @d
union select id,customer from DB2.dbo.orders where date > @d
...etc...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
-
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/
-
4 votes
We’ve released support for static code analysis mentioned in the comments in version 9 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
-
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
-
decimal
Hi, It would be great, if you add precision and scale on numeric/decimal data types - column hint and table summary.
3 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 -
Configurable Execution Warnings
The new Execution Warnings functionality to warn of UPDATE or DELETE statements without a WHERE clause is great; however, the warning triggers even when the code is in the definition of a Stored Procedure.
It would be good then to have advanced functionality to allow for us to be able to select whether to warn on SP definition text, or to turn on the warnings when running against temporary tables.
3 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 "closed tabs" to the tab history
Add a "closed tabs" list to the tab history - that's usually what I use it for rather than open tabs, which I try to keep to a minimum. That said it makes it hard when there are a dozen tabs all called "SQLQuery1", "SQLQuery2" to know which are open and which are closed...
3 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
SYSDATETIME() instead of GETDATE() as default value for datetime2 columns
When generating an insert script with default values for a table, use SYSDATETIME() instead of GETDATE() for datetime2 columns. GETDATE(), is fine for datetime columns, but for datetime2 columns, which have a larger precision SYSDATETIME() would be more appropriate.
3 votesThis is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
IF statement format options
Please provide the option to format IF statements as follows, based on the format settings sample.
IF @productType IN ('a', 'b', 'd', 'g', 'i', 'O', 'Q', 'X', 'Z') BEGIN
----IF @cost <= @compareprice BEGIN
--------PRINT 'Less than $' + CAST(@compareprice AS varchar(20))
----END ELSE BEGIN
--------PRINT 'Exceeds $' + CAST(@compareprice AS varchar(20))
----END
END
3 votesWe’ve released a brand new formatting system in version 8 of SQL Prompt and have made further improvements since.
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
-
Auto complete/intellisense suggestions using PIVOT
Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.
The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)
Ex:[code]CREATE TABLE dbo.tbTest(
Id INT,
foo VARCHAR(3),
bar FLOAT
)
GO
INSERT INTO dbo.tbTest
VALUES (1, 'foo', 2)
, (2, 'bar', 3)
, (3, 'foo', 4)
GO
SELECT *
FROM (
SELECT *
FROM dbo.tbTest AS tt
) pvt
PIVOT (
MAX(bar) FOR foo IN ([foo], [bar])
)p
[/code]…3 votesThis is included in SQL Prompt 7.1 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Qualify Ojects in SQL (Add square brackets)
When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:
CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));3 votesThis is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
- Don't see your idea?