679 results found
-
FIX Intellisense
I have version 10.0.1.12389 please have sql prompt STOP trying to complete things after a single Apostrophe. VERY Annoying
2 votes -
Disable prompt for major version upgrade when current license doesn't support it
Disable prompt for major version upgrade when current license doesn't support it
2 votes -
When typing between tics ' Intellisense is not needed.
at some point i noticed it started recommending suggestions when typing between ''. this should be a literal string with no suggestions required
2 votes -
inserting table adds database name
When you select a table from the intellisense list
Precede the table name with the database name as well
Currently it is only inserting the schema name in front of the table name
i.e. dbo.<table name>It should be <database name>.<schema name>.<table name>
2 votes -
Pin tab
So, Starred Tabs have been added, which is 1/2 of the capability I asked for a while back with "pinned tabs". We can remove tabs from Tab History either:
1 tab at a time.....100s of times per day for me
Older than x date - which does NOT work for me, because tabs that I want to keep around aren't always used every daySo, now that we can "Star" tabs, how about letting us clean up Tab History a little more cleanly. Such as:
1 tab at a time
Older than x, except Starred Tabs
Older than xThis…
2 votes -
Highlight difference between selected rows
Time to time you need to compare data in the rows, for example when looking for the cause of duplication. If the query is complex enough with joins and wide tables I usually run
SELECT * FROM ...
and check where the duplication begins to easily find the root cause. The easiest way for me to do so is to copy it into the excel and do some simple formula to find the exact columns that have difference.
It would be nice if SQL Prompt would support that feature. If it's possible then it can be done by highlighting needed…
2 votes -
Can we have a keyboard shortcut for "Script Object as ALTER"?
Can we have a keyboard shortcut for "Script Object as ALTER"? You had it before but it isn't available with the latest version.
2 votes -
Allow Copy/Paste contents of 'List of Code Analysis Issues' window.
Sometimes I would like to just copy/paste the issues discovered and include in an email. Currently, I cannot copy the Issues list. It takes too much time/effort to export to a file and then attach that file to an email. Copy/paste would be so much easier.
2 votes -
Allow query results to be editable grid
I would like to have the ability when using Redgate to develop a query as I do today in a new query window with all the object search and suggestions features currently offered in your product.
After I get the query returning the correct record set, I want to be able to edit the record set without having to copy the query and navigate to SSMS’s “Edit Top XXX Rows” menu item.
Editing a field on the row would update that field on that row when I move off the row.2 votes -
Make warning settings environment-specific
Hi RedGate Folks,
I think it would be helpful if the execution warnings settings were environment-specific. I.e., in the color coding section, we can establish which connections are prod, test, dev, etc. It would be great if I could -- for instance -- turn on warnings for DROP statements in my prod environment only.
2 votes -
Include auto fix for single quote string literals as aliases warning, Issue code: DEP01.
Create auto fix for Issue code: DEP01 non-standard column aliases because of single quote delimiter. Also need to update SQL Format tool, it is currently using single quote and there is no way I could find to switch it to double quote.
2 votes -
Refactor Select Into Statement as Create and Insert
I would like an efficient way to refactor this kind of statement...
SELECT ID, Name, Job INTO #Employee FROM Employees
into something like this-
CREATE TABLE #Employee (ID int, Name varchar(max), Job varchar(max))
INSERT INTO #Employee
SELECT ID, Name, Job
FROM EmployeesThe PE003 rule keeps triggering on these statements but it takes an annoyingly long time to write out the column definitions by hand for longer tables.
2 votes -
Aggrigate column name as
When writing SQL codes I frequently use aggregate functions such as Sum, count, avg etc.
When writing for exapmle sum(SalesVolume) it would be nice to have an autocomplete option to Sum(SalesVolume) As SalesVolume or Sum(SalesVolume) as SumSalesVolume.2 votes -
"Remove Square Brackets" option
The "Remove Square Brackets" option does not work for "CREATE EXTERNAL TABLE" statement.
Please try this option with the example below and nothing happens.
CREATE EXTERNAL TABLE [ft].[Account]
(
[AccountId] [bigint] NOT NULL,
[AccountType] [nvarchar] (50) COLLATE NOT NULL,
[AccountCreatedDate] [datetime2] NOT NULL
)
WITH
(
DATASOURCE = FinancialDB,
SCHEMANAME = 'Account',
OBJECT_NAME = 'Account'
);2 votes -
Tab History Add MRS
sometimes I need same string between different tabs in Tab History. each time I need to copy/paste the desired string. Would be nice if it would remember the most recent used searches same way as any Search box
2 votes -
Show last known value of T-SQL variables in pop-up definition
If I declare variables and assign them values (either in declaration or subsequent SET/SELECT statement, it would be very helpful if SQL Prompt, along with displaying the declaration (e.g. @MyVar int (Scalar variable) in the pop-up, would display the last know value. So, if my declaration was:
DECLARE @MyVar INT = 123
the popup would show something like @MyVar int = 123 (Scalar variable).
I realize some might be rather long (string) or not displayable at all (e.g. table variables, cursors, etc.) but what appropriate showing the value that was set and last known could be very helpful in line…2 votes -
Add option to ignore is_ms_shipped flag in suggestion list
When typing a snippet eg I type zcod I get 3 suggestions - but the top one is a merge replication conflict table definition for MSmergeConflictZZZFULLZZZcodt and the 2 below it are my own snippets starting with zcod
I don't understand why this is the case, my own suggestions that START with zcod should take precedence over an isms_shipped table that ends in zcod surely.
I see you recently added (I am on 9.5.11) ordering based on frequency and I never click this table as it serves no purpose so I cannot understand the behaviour.2 votes -
Provide optional colors for Warnings & Highlighting > highlighting
Options, Warnings & Highlighting, Highlighting. The light gray does not work well on a black background. I'd like to be able to select another color for that feature.
2 votes -
Vertically align option for concatenated strings
When concatenating strings, it'd be nice to be able to align the "+" sign. The following is what I get now:
SELECT CASE
WHEN Col = 1
THEN 'Col 1'
ELSE ''
END + CASE
WHEN Col = 2
THEN 'Col 2'
ELSE ''
END + CASE
WHEN Col = 3
THEN 'Col 3'
ELSE ''
END + CASE
WHEN Col = 4
THEN 'Col 4'
ELSE ''
END AS ConcatStr
FROM #Test;But what I'd like to get is:
SELECT CASE
WHEN Col = 1
THEN 'Col 1'
ELSE ''
END
+ CASE
WHEN Col = 2
THEN 'Col…2 votes -
Format lists on a clause basis
I would like to control the list behavior on a clause by clause basis so that I can separate the formatting on my DECLARE statements differently than lists within SELECT and INSERT statements. As it stands, these are conflicting changes. So, the only way to get each variable declared on a separate line is to also have every column in other statements on a separate line. I'd like to be able to do BOTH of these:
DECLARE @GUID UNIQUEIDENTIFIER = NEWID(),
@Char CHAR(1) = 'A',
@Int INT = 1,
@Datetime DATETIME = CURRENTTIMESTAMP,
@Decimal DECIMAL(18,10) = 1.0,
@Date DATE…2 votes
- Don't see your idea?