662 results found
-
Apply SQL Prompt Styles with Code
I'd like a NuGet lib to be able to apply SQL Prompt styles to a folder of .sql files or a StreamReader string. I have a console app I'm using to produce a lot of Sql Files and I'd like to create a "everything on one-line" style that I use internally when processing things. There could be tons of other uses as well.
1 vote -
Insert Default Values should include default values defined on the table.
For example, if a table is defined as such :
CREATE TABLE dbo.T1 (
col1 INT DEFAULT 100,
col2 VARCHAR(100) DEFAULT 'Example',
col3 DATETIME DEFAULT '01/01/2019'
)And use auto-complete to generate and INSERT, it will produce :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 0 -- col1 - int
,'' -- col2 - varchar(100)
,GETDATE() -- col3 - datetime
)Instead, it would be nice to have it produce the insert with the defined table default's, something like :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 100 -- col1 - int
,'Example' -- col2 - varchar(100)
,'01/01/2019…5 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 -
SSMS add a pane with a vertical list of open queries
Request title:
SSMS add a pane with a vertical list of open queries
Description:
In SSMS add a pane with a vertical list of open queries similar to the Object Explorer pane that can be docked/undocked that you can see the entire file name and quickly navigate or choose from the entire list of tabs of open query files to choose from.
So, instead of horizontal tabs where the file name and other details that are partially hidden or don’t appear if many files are open, have an option to show a vertical list of open files.
Add ability to…1 vote -
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 -
Copy as WHERE clause
It would be useful to be able to copy a selection from the results grid which is pre-formatted as a WHERE clause in the same way "Copy as clause" IN works, e.g. copying a single value from ProductID column would produce WHERE ProductID = 5 and copying multiple values would produce WHERE ProductID in ( 5, 10, 15 ).
4 votes -
Add space between closing parethesis of a function call and FROM
Add an option to add a space between a function call, such as COUNT(), and FROM so that we don't end up with code like SELECT COUNT()FROM table. That doesn't happen when I select "Add spaces around parentheses" in the global parentheses options. The only way I've been able to get SQL Prompt to preserve that space is to select "Add spaces around parentheses" in the Function calls options, but I don't want a space between the function name and opening parenthesis.
4 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 -
BIgger dropdown for the actions list
Selecting code then pressing CTRL brings up the action list, but only 6 items are shown in this list, meaning that for many uses, scrolling or searching (moving is required. A longer list (ideally user-settable) would mean moving mouse directly to most items and selecting is possible.
1 vote -
Send to Tab History
I would like a hot key combination to send the contents of my current tab to 'Tab History' without having to close the tab. There are times that I know I will need the contents of the tab in the near future (within a few hours/days) and I don't want to have to save a hard copy to my disk.
6 votes -
Make the Issues List more useful - Rule Disable, Specific Help, Hide Issue in List
The list is useful to drive code positioning, but that's all it does. Rules like ST011 that go against authoritative SQLPass presentations are noise. Yes, we can click the SQP Menu, nav to manage, scroll down, and finally disable, save, then refresh... (out of breath!). Just right-click and Disable rule, which also refreshes the list. That kind of useful RC-Menu. And instead of having to go to the Rule Maint to see exactly what the rule is enforcing, RC-menu has "Show Issue Help" in a bubble, built in. And for those cases where a rule isn't to be shut down,…
4 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 -
too much prompting for upgrades
I'm constantly opening new SSMS windows, closing new ones, opening new visual studio windows, etc, and every time I open a new window, I have to acknowledge the upgrade prompt because it covers important parts of the window (like the status bar). Even if I select "next month" or "skip this version" I have to do the same for every new window I open since new sessions don't check for this option on existing sessions. SQL prompt is constantly getting updates (almost weekly, it seems), so i just start a new round of "skip this version" the following week.
Can…
3 votes -
Temporarily Elevate Exact Matches Over Recently Used Suggestions
I like the new feature to put recently-selected items at the top of the list for Intellisense. However, when I have typed an exact match, I would like to see Intellisense elevate that exact object to the top of the list.
For example, suppose I have recently selected a table named "dbo.OrderDetail", and suppose that there is another table in the same database called dbo.Order. With the new feature, I cannot access "dbo.Order" as the top candidate, because it is a partial match of "dbo.OrderDetail," and so SQLPrompt puts that name at the top.
In a nutshell, I would like…
6 votes -
Copy grid result as json
I hope can do this:
- in grid result, select all or part cells.
- click right button, in context menu, exists a "Copy as json" item.
- click "Copy as json", in other place paste, get json texts.
1 vote -
conditions new line after
Currently we have a standard of placing new line before and after conditions with indent accordingly such that:
a=1
AND
b=2Current version only does:
a=1
AND b=2This is pretty much the only thing lacking from being able to just auto format all our procedures with a single click.
4 votes -
Support SSDT for SQL Prompt
Create Install Package for installing SQL Prompt in SSDT. SSDT is a VS shell, so Prompt should be easily incorporated.
5 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 -
compare datatypes in stored procedure calls with defined variables
When I call a stored procedure, I want SQL Prompt's code analysis rules to be able to tell me if the variables I am passing to the stored procedure are OK.
For example, if I pass a bigint variable to a SP that has a tinyint input parameter, I want SQL prompt to flag that as a potential issue.
Similarly, if I am passing a string variable defined locally as nvarchar(150) to a SP that takes only nvarchar(100), it should be flagged as an issue (because I am passing a string that may not "fit" into the input parameter).
3 votes
- Don't see your idea?